VLookup with Multi Range

[Budge]

I have 2 ranges where my lookup value can reside.It can be in either one.
I've been searching the board for clues and have found this
=if(isna(vlookup1),vlookup2,vlookup1)

So translating it for my purposes
=if(isna(vlookup(a1,Range1,2,0),vlookup(a1,Range2,2,0),vlookup(a1,Range1,2,0))

I tried the formula exactly as per the first example without the brackets joining lookup2 and then lookup1.No luck.
Have tried various combinations,all to no avail.
Please advise

Sincerely,
Budge

 

[PaddyD]

On 2002-09-01 15:16, Budge wrote:
I have 2 ranges where my lookup value can reside.It can be in either one.
I've been searching the board for clues and have found this
=if(isna(vlookup1),vlookup2,vlookup1)

So translating it for my purposes
=if(isna(vlookup(a1,Range1,2,0),vlookup(a1,Range2,2,0),vlookup(a1,Range1,2,0))

I tried the formula exactly as per the first example without the brackets joining lookup2 and then lookup1.No luck.
Have tried various combinations,all to no avail.
Please advise

Sincerely,
Budge

looks like you're just missing one bracket:

=IF(ISNA(VLOOKUP(A1,Range1,2,0)),VLOOKUP(A1,Range2,2,0),VLOOKUP(A1,Range1,2,0))

paddy

 

[Budge]

Thanks Paddy.

Budge