Dear Gurus,
As always, I am relying on your skills to help me solve the following problem. I need Excel to return a value from a table using two criteria as the basis of choice. I have added a more detailed explanation in the attached file. Your help is much appreciated!
Agnese
Last edited by Agnese; 03-15-2016 at 04:27 AM.
Try using
=IF(ISERROR(INDEX($C$14:$G$17, MATCH($B6,$B$14:$B$17,0), MATCH(C6,$C$13:$G$13,0))),0,INDEX($C$14:$G$17, MATCH($B6,$B$14:$B$17,0), MATCH(C6,$C$13:$G$13,0)))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Given that your profile says 2007 and the file extension is .xlsx, you could just use:rather than repeating the INDEX/MATCH within an IF(ISERROR(...))Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks