Can vlookup do a multi-column match...if not then what
Thanks that's a winner
"Mike H" wrote:
Dave,
You would use index - match for that. try this array formula (see below) In
practice i'd use cell references for Bob & 3
=INDEX(C1:C6,MATCH(1,(A1:A6="Bob")*(B1:B6=3),0))
This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array
Mike
"Dave" wrote:
I want to do a multi column lookup.
If I Match"
Bob with 2, I would get b
John with 2, I would get e
Will vlookup do this?
Col1 Col2 Col3
Bob 1 a
Bob 2 b
Bob 3 c
John 1 d
John 2 e
John 3 f
|