Vlookup

[eedie]

Hi,

When I use a standard vlookup formula with the data below, it returns wrong data.

A B
- -

m1 40
e1 50
p1 60
m2 70
e2 80
p2 90
m3 120
e3 130
p3 140

Cheers

 

[eedie]

OK,

Its sorted. I forgot to sort column A

Cheers

 

[SkipVought]

Hi,

WHAT formula? VLOOKUP can be used and missused.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[AnotherHiggins]

Without knowing what you were trying to do it is impossible to say for sure, but if the last argument of the VLOOKUP is FALSE (or zero), you likely won't have to sort the data!

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.