Look UP using 3 conditions
 

Hello,

Please refer the attached worksheet and kindly suggest a look up formula using three conditions.

I am having trouble attachingthe file on to this site, hence uploaded on to speedyshare. please see link below

http://speedy.sh/PrG5n/Look-Up-formu...conditions.xls

Any help will be greatly appreciated

Thanks
Excel DUmbo

Hi Excel Dumbo

See the attached file using INDEX & MATCH. I named 3 ranges for the 3 tables. Also I have named TMF ACRYLIC 1-P to TMF_ACRYLIC_1_P as naming ranges wont accept spaces or hyphens, that is the only change to your data.

Kevin

Hi Kevin,

THanks for your reply. I am using Excel 2003. You are using the formula that will be suiting the advanced excel version. Could you please suggesta formula for Excel 2003. I am sorry I should have pointed this out earlier.


Regards,
Excel Dumbo

Hi Excel Dumbo

Then you just need to replace the IFERROR with IF & ISERROR.

=IF(ISERROR(INDEX(INDIRECT($C2),MATCH($A2,$A$34:$A $45,0),MATCH($B2,$E$34:$P$34,0))),"",INDEX(INDIREC T($C2),MATCH($A2,$A$34:$A$45,0),MATCH($B2,$E$34:$P $34,0)))

I would upload a xls file, but you cannot upload anything on this site and it is a waste of time using the "Contact Us" in the link at the bottom of the page as they don't bother to reply!!!

Kevin

Thanks Kevin for your solution