View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 71
Default How to expand Index/Match formula

I have the following formula below, but I want the formula to also
match columnD in addition to columnA on my Data! sheet. ColumnA and
ColumnD on Data! needs to match ColumnC and ColumnE respectively
before returning columnE from Data! on my other sheet.


=INDEX(Data!E:E,MATCH(C2,Data!A:A,0))

Any ideas?