Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 Quote:
Last edited by Kevin@Radstock : February 16th 13 at 10:07 AM |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 Last edited by Kevin@Radstock : February 14th 13 at 08:37 AM |
#5
|
|||
|
|||
Thanks Kevin for your solution
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
If, or on 3 conditions | Excel Programming | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |