Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup in to columns | Excel Worksheet Functions | |||
Vlookup from 2 columns | Excel Worksheet Functions | |||
VLookup against one of two columns | Excel Worksheet Functions | |||
Vlookup using two columns | Excel Worksheet Functions | |||
Vlookup with 2 columns | Excel Discussion (Misc queries) |