Spreadsheet: 70889d1271665185-identifying-a-cell-in-a-range-from-its-value-dummy-workbook-with-formula
Sheet: Feuil1

 | T2 |  |  | Tot  T2 | T3 |  |  | Tot  T3 | T4 |  |  | Tot  T4 | T1 |  |  | Tot  T1 | T2 |  |  | Tot  T2 | T3 |  |  | Tot  T3 | T4 |  |  | Tot  T4 | T1 |  |  | Tot  T1 | T2 |  |  | Tot  T2 | T3 |  |  | Tot  T3 | T4 |  |  | Tot  T4
 | Avr | Mai | Jun |  | Jul | Aug | Sep |  | Oct | Nov | Dec |  | Jan | Fev | Mar |  | Avr | Mai | Jun |  | Jul | Aug | Sep |  | Oct | Nov | Dec |  | Jan | Fev | Mar |  | Avr | Mai | Jun |  | Jul | Aug | Sep |  | Oct | Nov | Dec
Date | 2010-04-15 00:00:00 | 2010-05-15 00:00:00 | 2010-06-15 00:00:00 |  | 2010-07-15 00:00:00 | 2010-08-15 00:00:00 | 2010-09-15 00:00:00 |  | 2010-10-15 00:00:00 | 2010-11-15 00:00:00 | 2010-12-15 00:00:00 |  | 2011-01-15 00:00:00 | 2011-02-15 00:00:00 | 2011-03-15 00:00:00 |  | 2011-04-15 00:00:00 | 2011-05-15 00:00:00 | 2011-06-15 00:00:00 |  | 2011-07-15 00:00:00 | 2011-08-15 00:00:00 | 2011-09-15 00:00:00 |  | 2011-10-15 00:00:00 | 2011-11-15 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2012-01-15 00:00:00 | 2012-02-15 00:00:00 | 2012-03-15 00:00:00 |  | 2012-04-15 00:00:00 | 2012-05-15 00:00:00 | 2012-06-15 00:00:00 |  | 2012-07-15 00:00:00 | 2012-08-15 00:00:00 | 2012-09-15 00:00:00 |  | 2012-10-15 00:00:00 | 2012-11-15 00:00:00 | 2012-12-15 00:00:00
Prod A | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 2 | 1 | 0 |  | 1 |  | 1 |  | 1 |  |  |  | 0 |  |  | 1 | 1 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
cumul.prod.A | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 1 | 0 | 2 |  | 3 | 0 | 4 |  | 5 | 0 | 0 |  | 0 | 6 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 7 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
RANK | 1 | 0 | 4 |  | 5 | 0 | 7 |  | 8 | 0 | 0 |  | 0 | 10 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 12 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Prod B | 1 | 1 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 |  |  |  | 0 |  | 1 |  | 1 |  |  |  | 0 |  |  | 1 | 1 |  |  |  | 0 | 1 |  |  | 1 |  | 1 |  | 1 |  |  | 1 | 1
cumul.prod.B | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 9 | 9
 | 1 | 2 | 0 |  | 3 | 0 | 0 |  | 0 | 4 | 0 |  | 0 | 0 | 0 |  | 0 | 5 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 6 |  | 0 | 0 | 0 |  | 7 | 0 | 0 |  | 0 | 8 | 0 |  | 0 | 0 | 9
RANK | 2 | 3 | 0 |  | 6 | 0 | 0 |  | 0 | 9 | 0 |  | 0 | 0 | 0 |  | 0 | 11 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 13 |  | 0 | 0 | 0 |  | 14 | 0 | 0 |  | 0 | 15 | 0 |  | 0 | 0 | 16
 | Whenever a product A or B is sold, it is written on the corresponding line (green cells). (Only 1 product by type and by month)
 | Then a unique "rank", or record number, is assigned to each of these sales (pink cells)
 | Number of sales : |  | 15
 | What I need to do is, starting from a list from 1 to the [NAME]. number of sales (15 here), is to search, among the cells in line 10 and 14
 | (those with the ranks of the transactions) to obtain the address of the one of which the value matches the desired rank:
 | eg | Rank | Cell
 |  | 1 | #N/A |  | Once I have this it allows me to gather the month and product type of the transaction.
 |  | 2 | B14
 |  | 3 | C14
 |  | etc.. | etc…