Sheet 1
A=service ticket #
B=person name
C=part number
D= create date
I am trying to look up the value in column A, based on criteria
I want to say - if you can find/match “John Smith” in column B, and part number “abc-x” in column C, then return column A service ticket #.
If name and part # match, then search “service ticket” column for service ticket number.
Thx in advance.
Hi JulieQ,
You need something like this:
=IFERROR(INDEX($A$1:$A$11,MATCH(F2&G2,$C$1:$C$11&$B$1:$B$11,0),0),"No Match")
Find it in the attached example.
Index Match 2 columns.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
In the same file Enclosed by MarvinP Try this
=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($C$1:$C$11)/(($C$1:$C$11=$F2)*($B$1:$B$11=$G2)),1)),"No Match")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Please try
=iferror(lookup(1,1/(B$1:B$100="John Smith")/(C$1:C$100="abc-x"),A$1:A$100),"")
Thank-you! I went with: =IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($C:$C)/(($C:$C=$F2)*($B:$B=$G2)),1)),"No Match")
Pl mark the thread solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks