VLOOKUP

[ds_robb]

Has anyone else come across a problem in Excel 2002 where VLOOKUP appears to return the wrong results?. I have two columns (Client and Project):

A1 B1
CLIENT A PRO0001
CLIENT B PRO0002
CLIENT C PRO0003
CLIENT D PRO0004
CLIENT E PRO0005

The following VLOOKUP is used

VLOOKUP(C1,A1:B4,2,TRUE) and seems to work most of the time (C1 by the way is a drop down list complied from A1:A5).

But when I select CLIENT B - nothing is returned for the lookup and when I select CLIENT D - I get PRO00002 which should be for B.... anyone seen anything like this?

 

[Aladin Akyurek]

On 2002-08-31 14:05, ds_robb wrote:
Has anyone else come across a problem in Excel 2002 where VLOOKUP appears to return the wrong results?. I have two columns (Client and Project):

A1 B1
CLIENT A PRO0001
CLIENT B PRO0002
CLIENT C PRO0003
CLIENT D PRO0004
CLIENT E PRO0005

The following VLOOKUP is used

VLOOKUP(C1,A1:B4,2,TRUE) and seems to work most of the time (C1 by the way is a drop down list complied from A1:A5).

But when I select CLIENT B - nothing is returned for the lookup and when I select CLIENT D - I get PRO00002 which should be for B.... anyone seen anything like this?

Switch to:

VLOOKUP(C1,A1:B4,2,0)

where 0 is read by Excel as FALSE (1 as TRUE).
This message was edited by Aladin Akyurek on 2002-08-31 14:07

 

[ds_robb]

Sorry, re-read the VLOOKUP Syntax properly this time and TRUE should be FALSE as the list is not alphabetically sorted... sorry