VLOOKUP range question [Solved/Closed]

Question

Previous Topic Next Topic

VLOOKUP range question [Solved/Closed]

Report

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!

VLOOKUP range question
VLOOKUP, IF? Question assigning value to text options ✓ - Forum - Excel
A strange Range question ... ✓ - Forum - Excel
Yahoo mail forgot password and security question - How-To - Yahoo mail
Wimax frequency range - Articles
When i type a question mark i get an underscore ✓ - Forum - Keyboard

1 reply

Ask a question

mjaybee · Answer 1 · 2013-01-17T10:05:20-0500

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.

VLOOKUP range question [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!