Lookup, looking up one row above the actual row
 

Excel Lookup Problem.

Lets say I have a spreatsheet like this:

12_11 123
34_15 457
56_18 80
90_21 67

When I am using Vlookup("90_21", range, 2) I get an answer 80.

Ofcourse, my actual spreadhseet is much bigger and different than the above.

Any help why the lookup is looking at one row above the actual row it should
be looking up.

Please let me know if there is a way I can upload the spreadsheet so that I
can let the Gurus troubleshoot more effectively.

Thanks
Mario

Lookup, looking up one row above the actual row
 

You are welcome to e-mail to me at (nospam) and I will take
a look.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"mario" wrote:

Excel Lookup Problem.

Lets say I have a spreatsheet like this:

12_11 123
34_15 457
56_18 80
90_21 67

When I am using Vlookup("90_21", range, 2) I get an answer 80.

Ofcourse, my actual spreadhseet is much bigger and different than the above.

Any help why the lookup is looking at one row above the actual row it should
be looking up.

Please let me know if there is a way I can upload the spreadsheet so that I
can let the Gurus troubleshoot more effectively.

Thanks
Mario

Lookup, looking up one row above the actual row
 

Mario

Set the optional 4th argument to false (or zero):

=Vlookup("90_21", range, 2,0)

Richard


mario wrote:
Excel Lookup Problem.

Lets say I have a spreatsheet like this:

12_11 123
34_15 457
56_18 80
90_21 67

When I am using Vlookup("90_21", range, 2) I get an answer 80.

Ofcourse, my actual spreadhseet is much bigger and different than the above.

Any help why the lookup is looking at one row above the actual row it should
be looking up.

Please let me know if there is a way I can upload the spreadsheet so that I
can let the Gurus troubleshoot more effectively.

Thanks
Mario

Lookup, looking up one row above the actual row
 

one way
=INDEX(D:D,MATCH("90_21",C:C)-1)

--
Don Guillett
SalesAid Software

"mario" wrote in message
...
Excel Lookup Problem.

Lets say I have a spreatsheet like this:

12_11 123
34_15 457
56_18 80
90_21 67

When I am using Vlookup("90_21", range, 2) I get an answer 80.

Ofcourse, my actual spreadhseet is much bigger and different than the
above.

Any help why the lookup is looking at one row above the actual row it
should
be looking up.

Please let me know if there is a way I can upload the spreadsheet so that
I
can let the Gurus troubleshoot more effectively.

Thanks
Mario

Lookup, looking up one row above the actual row
 

Looks like 3 spaces at the end of all of the data, check e-mail
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Don Guillett" wrote:

one way
=INDEX(D:D,MATCH("90_21",C:C)-1)

--
Don Guillett
SalesAid Software

"mario" wrote in message
...
Excel Lookup Problem.

Lets say I have a spreatsheet like this:

12_11 123
34_15 457
56_18 80
90_21 67

When I am using Vlookup("90_21", range, 2) I get an answer 80.

Ofcourse, my actual spreadhseet is much bigger and different than the
above.

Any help why the lookup is looking at one row above the actual row it
should
be looking up.

Please let me know if there is a way I can upload the spreadsheet so that
I
can let the Gurus troubleshoot more effectively.

Thanks
Mario