Thread: Look UP using 3 conditions
View Single Post
  #2   Report Post  
Kevin@Radstock Kevin@Radstock is offline
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 10:07 AM
Reply With QuoteReply With Quote