On sheet DB I want a formula that looks at what is in cell F3 and G3 and if what is in F3 and G3 is a match for what is on Sheet2 in col B and C (on the same row) then I want to return whatever is in Sheet2 column Q on the same row where the match was found.
=IFERROR(INDEX(Sheet2!$Q$2:$Q$1000,MATCH(F3&G3,Sheet2!$B$2:$B$1000&Sheet2!$C$2:$C$1000,0)),"")
Confirm Control+Shift+Enter
or non-aray
=IFERROR(INDEX(Sheet2!$Q$2:$Q$1000,MATCH(TRUE,INDEX(Sheet2!$B$2:$B$1000&Sheet2!$C$2:$C$1000=F3&G3,0),0)),"")
Last edited by RobertMika; 10-09-2013 at 02:28 PM.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
ScabbyDog,
Here are two different approaches. You will need to change the ranges as necessary:
Please Login or Register to view this content.[EDIT]: Beat to it by RobertPlease Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks. Both work great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks