As in attached spreadsheet, I need to look up values in Column B + Column E in Sheet1, that will return the corresponding value of Column O into Sheet 2, Column F.
I've gotten as far as looking up the values in Column B and returning Column O into Sheet2, but that doesn't help me.
Will the IF(AND statement work in the respect, and if not, what will?
Thanks in advance!
HOW ABOUT
=INDEX(Sheet1!$O$4:$O$100,MATCH(A3&B3,Sheet1!$B$4:$B$100&Sheet1!$E$4:$E$100,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.
Thank you very much.
That works, but I need to be able to return a blank cell if there is an error or a zero. That's why I had the IFERROR in the example.
Got it. Thank you very much.Originally Posted by etaf
Figured out the IFERROR as well.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks