Previous Topic Next Topic

VLOOKUP range question

Solved/Closed
mjaybee Posts 5 Registration date Wednesday January 16, 2013 Status Member Last seen January 17, 2013 - Jan 17, 2013 at 09:48 AM
mjaybee Posts 5 Registration date Wednesday January 16, 2013 Status Member Last seen January 17, 2013 - Jan 17, 2013 at 10:05 AM
Hello,

=VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE)

I'm using this formula in my spreadsheet and it is working EXCEPT
when the new spreadsheet has inserted enough rows that my target cell on spreadsheet 1 isn't included.

For example

OLD contains '4412' in Row 32 Col A
NEW contains '4412' in Row 41 Col A
and the formula is =VLOOKUP(A41,OLD!$A38:$B1441,2,FALSE)

Since 4412 is in Row 32, it isn't finding it because it doesn't start searching until A38.

Please help!

Thank you!

1 response

Answer 1 / 1
mjaybee Posts 5 Registration date Wednesday January 16, 2013 Status Member Last seen January 17, 2013
Jan 17, 2013 at 10:05 AM
I see what happened...I forgot the $ for the columns.

=VLOOKUP(A5,OLD!$A$1:$B$1404,2,FALSE)

Oops.
0

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
My account locked connect to gemail
Karthik -
winko -

2 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses