Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 105
Default 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   Report Post  
Member
 
Posts: 93
Default

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:
Originally Posted by Excel Dumbo View Post
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
Attached Files
File Type: zip 004-Look Up formual using 3 conditions.zip (17.7 KB, 44 views)

Last edited by Kevin@Radstock : February 16th 13 at 11:07 AM
  #3   Report Post  
Senior Member
 
Posts: 105
Default

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   Report Post  
Member
 
Posts: 93
Default

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

Quote:
Originally Posted by Excel Dumbo View Post
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

Last edited by Kevin@Radstock : February 14th 13 at 09:37 AM
  #5   Report Post  
Senior Member
 
Posts: 105
Default

Thanks Kevin for your solution
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif Conditions - Use of conditions that vary by cell value JonTarg Excel Discussion (Misc queries) 1 May 30th 08 01:21 PM
2 Conditions + Sum of a colum matching those conditions Jeffa Excel Worksheet Functions 5 June 8th 07 12:14 AM
shade cells based on conditions - i have more than 3 conditions Mo2 Excel Worksheet Functions 3 March 30th 07 07:19 AM
If, or on 3 conditions Darin Kramer Excel Programming 2 September 5th 05 04:13 PM
How to multiple conditions to validate more than 2 conditions to . Bhuvana Govind Excel Worksheet Functions 1 January 28th 05 08:07 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"