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

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?

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