Lookup Help

[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

 

[Cold_Zero]

Can excel even do this

 

[Frank Kabel]

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

 

[Cold_Zero]

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