VLOOKUP for 2 columns or more
 

I have this formula in SHEET 1 pasted all the way down in B ( 65536 cells ):
=VLOOKUP(A1,SHEET2!$A:$B,2,FALSE)
When I write in A ( any cell, SHEET 1) the formula look and fill up B column
accordinly to the data in SHEET 2 ( A and B columns ). Now as I ran out of
cells I'd like to ADD to this formula another look up for C and D , and
possible for E and F in SHEET 2 that will look up there and give the outcome
in the same A and B rows of SHEET 1.
I tried this one without results :
=VLOOKUP(A1,SHEET2!$A:$B,2,FALSE)+vlookup(a1,sheet 2!$c:$d,2,false)
Please change what I wrote in lower case(above) to replace it for a working
formula for this situation. Thanks.

VLOOKUP for 2 columns or more
 

Maybe something like this........

=IF(ISNA(VLOOKUP1),VLOOKUP2,VLOOKUP1)

Vaya con Dios,
Chuck, CABGx3


"FC" wrote in message
...
I have this formula in SHEET 1 pasted all the way down in B ( 65536
cells ):
=VLOOKUP(A1,SHEET2!$A:$B,2,FALSE)
When I write in A ( any cell, SHEET 1) the formula look and fill up B
column
accordinly to the data in SHEET 2 ( A and B columns ). Now as I ran out of
cells I'd like to ADD to this formula another look up for C and D , and
possible for E and F in SHEET 2 that will look up there and give the
outcome
in the same A and B rows of SHEET 1.
I tried this one without results :
=VLOOKUP(A1,SHEET2!$A:$B,2,FALSE)+vlookup(a1,sheet 2!$c:$d,2,false)
Please change what I wrote in lower case(above) to replace it for a
working
formula for this situation. Thanks.