View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
 
Posts: 256
Default index,match - how to avoid same lookup when duplicates present

In article ,
Nick wrote:

Thanks very much for that...


You're very welcome!

In reality, the value 12 is unkown, it is found from an
INDEX/MATCH...


Replace the number 12 with a reference to the cell containing the
INDEX/MATCH formula. So, for example, if D2 contains the INDEX/MATCH
formula, replace...

=12

with

=D2

also the row A2 would be unknown when constructing the function.


Can you elaborate?