VLOOKUP with 2 criteria

[Guest]

hi,

I have the following:

=VLOOKUP(F2,'SHEET_NAME'!B:G,6,FALSE)

I would like to know how I can add another criteria to this VLOOKUP, like
instead of just looking at F2, I want it to look at F2 and A2. Is there a
way to do this, or a better way?


thanks in advance,
geebee

 

[jwonder]

hi,

I have the following:

=VLOOKUP(F2,'SHEET_NAME'!B:G,6,FALSE)

I would like to know how I can add another criteria to this VLOOKUP, like
instead of just looking at F2, I want it to look at F2 and A2. Is there a
way to do this, or a better way?

thanks in advance,
geebee

Can you explain a little more of what you are trying to do? Why do
you need both F2 and A2? Maybe the INDEX() function will work?

 

[Bob Phillips]

If the concatenated value of B2 and F2 is in column B, then

=VLOOKUP(B2&F2,'SHEET_NAME'!B:G,6,FALSE)

if they are separate in say Band C then

=INDEX(G1:G1000,MATCH(1,(B2='SHEET NAME'!B1:B1000)*(F2='SHEET
NAME'!C1:C1000),0))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)