Hi all,
I have been trying to do what is described in the title but cannot do it! I have been trying to do if vlookups match or something but I cannot get it to work - does anyone have any ideas?
Columns 1 and columns 2 in my source data have various different pairs. If my pair exists as a pair in the first table then I want the third value to be returned.
Thanks
Could you post a small sample of your data please?
=INDEX($C$1:$C$6,MATCH(E1&F1,$A$1:$A$6&$B$1:$B$6,0))
where E1 and F1 contain the two search values to be combined. Adjust th eranges as required.
Array entered with Ctrl-Shift-Enter rather than just Enter
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
when I have a similar situation, I concatenate the values & then I try Vlookup
Regards
Mani
a non array entered version of index match is
=INDEX($C$1:$C$6,MATCH(E1&F1,INDEX($A$1:$A$6&$B$1:$B$6,0),0))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks