Vlookup

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Trying a simple lookup and the returned value is
consistently one row higher than it should be, even if
using a FALSE statement. Has anyone come across a
similar situation and how did you correct it?
 
Hi Eric
this should do. Strange. If you like you can email me your file and
I'll have a look at it
mail: frank[dot]kabel[at]freenet[dot]de
 
Frank,

I sent it to you. Let me know what you think.
-----Original Message-----
Hi Eric
this should do. Strange. If you like you can email me your file and
I'll have a look at it
mail: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Here's the formula... Pretty straight forward.

=VLOOKUP(F6,B7:C118,2,FALSE)
Click to expand...

.
Click to expand...
 
Hi Eric
this is a strange Excel formating issue. To solve this you can either
go into each cell and hit Enter in the formula bar or try the
following:
- select the cells in column B
- goto 'Data - Text to columns'
- just step through the wizard

After this it works for me.

--
Regards
Frank Kabel
Frankfurt, Germany

Frank,

I sent it to you. Let me know what you think.
-----Original Message-----
Hi Eric
this should do. Strange. If you like you can email me your file and
I'll have a look at it
mail: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Here's the formula... Pretty straight forward.

=VLOOKUP(F6,B7:C118,2,FALSE)


-----Original Message-----
Hi Eric
could you post your formula.

--
Regards
Frank Kabel
Frankfurt, Germany


Eric wrote:
Trying a simple lookup and the returned value is
consistently one row higher than it should be, even if
using a FALSE statement. Has anyone come across a
similar situation and how did you correct it?
.
Click to expand...

.
Click to expand...
Click to expand...
 
Make sure that the information in the first column of
your lookup page is sorted in ascending order.
 
Back
Top