Thread
:
Excel: match two cells in one sheet to two cells in another and return a third cells value
View Single Post
#
4
sudarshan1026
Junior Member
Posts: 1
Hi All,
My question is simple. below is the table. I want to match two cells in first set of data with the second set of data and return the value of Column "Job Status" in first set from the second set data.
First Set
Date Aired Home Team Away Team Job Status
23-Oct-10 Dallas Stars Nashville Predators
7-Oct-10 Minnesota Wild Carolina Hurricanes
7-Oct-10 Toronto Maple Leafs Montreal Canadiens
7-Oct-10 Pittsburgh Penguins Philadelphia Flyers
Second Set
Date Home Team Away Team Job Status
23-Oct-10 Dallas Stars Nashville Predators Upload Complete
26-Oct-10 Dallas Stars Anaheim Ducks Upload Complete
30-Oct-10 Dallas Stars Buffalo Sabres Upload Complete
3-Nov-10 Dallas Stars Pittsburgh Penguins Upload Complete
1-Feb-11 Dallas Stars Vancouver Canucks VD Created
Please mail me the solution for this :
Quote:
Originally Posted by
Biff
Hi!
Can you post an example?
I'll bet you want something like this:
=INDEX(third column of sheet1,MATCH(two columns of sheet2,two columns in
sheet1,0))
If you had said where all this stuff is specifically located, then the
formula would look something like this:
=INDEX(Sheet1!C1:C100,MATCH(A1&B1,Sheet1!A1:A100&S heet1!B1:B100,0))
Array entered.
When you include details we don't have to guess!
Biff
"Spence" wrote in message
oups.com...
I want to reference cells in two columns in sheet1 and when the
criteria matches cells in two columns of sheet2 I want to return the
value in the third column of sheet1 to the third column of sheet2?
Does that make sense? Vlookup won't work here because I want to match
two columns in the same array. I thought Indexing would work but I
keep coming up with an error. I also tried to do a Match/Offset
formula from Chip Pearson's website but that wasn't what I was looking
for. Any help is much appreciated.
Thanks,
Spence
Reply With Quote
sudarshan1026
View Public Profile
Send a private message to sudarshan1026
Find all posts by sudarshan1026