Lookup Help

  • Thread starter Thread starter Cold_Zero
  • Start date Start date
C

Cold_Zero

In the enclosed spreadsheet, I am trying to match E1 and F1 to the dat
in A1:C5. If there is an exact match I need the value in Column C t
populate. I can not use a simple vlookup to match what is in column
to column A since the data in column B is different.

thank you,
bu

Attachment filename: help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45548
 
Hi
try the following array entered (CTRL+SHIFT+ENTER) formula in cell G1:
=INDEX($C$1:$C$7,MATCH(E1&F1,$A$1:$A$7&$B$1:$B$7,0))
and copy down
 
For some strange reason I have to hit shift+control+enter. But it di
work. Thanks a million for your help. Now I have to go sort som
spreadsheets.
Thank you,
bu
 
Back
Top