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.