Look UP using 3 conditions

[Excel Dumbo]

Hello,

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

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

http://speedy.sh/PrG5n/Look-Up-formual-using-3-conditions.xls

Any help will be greatly appreciated

Thanks
Excel DUmb

 

[Kevin@Radstock]

Hi Excel Dumbo

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

Kevin

http://tinyurl.com/bpcdt5s

 

[Excel Dumbo]

Hi Kevin,

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


Regards,
Excel Dumb

 

[Kevin@Radstock]

Hi Excel Dumb

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(INDIRECT($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 sit
and it is a waste of time using the "Contact Us" in the link at th
bottom of the page as they don't bother to reply!!

Kevi

 

[Excel Dumbo]

Thanks Kevin for your solutio

+-------------------------------------------------------------------
+-------------------------------------------------------------------