VLOOKUP with 2 criteria
 

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

VLOOKUP with 2 criteria
 

On Nov 1, 10:54 am, geebee (noSPAMs) wrote:
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?

VLOOKUP with 2 criteria
 

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)



"geebee" (noSPAMs) wrote in message
...
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