VLOOKUP - Wrong Value Return

[MysticalNomad]

I have a spreadsheet that will lookup an Object name based on the Objec
code. The Object codes are Q,R,F,M,W and Msg and the Object names ar
Query, Report, Form, Macro, Warnings and Messages.

When I type the code into (for example) A1, the Object name shoul
appear in B1. I have named the lookup chart "Objects" and the formul
for B1 is:

=IF(A1="","",VLOOKUP(A1, Objects, 2))

The wrong value is returned, i.e Q is typed in and Macro is returned
What's going on?
I have attached the spreadsheet for you to look at.

Please help..

Attachment filename: lookup.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66455

 

[Richard]

Hi this is a simple problem, you are missing the last part of the formula
you need to change it to IF(A1="","",VLOOKUP(A1, Objects, 2,false)) this
is
because you list in not in alpha order.


I have a spreadsheet that will lookup an Object name based on the Object
code. The Object codes are Q,R,F,M,W and Msg and the Object names are
Query, Report, Form, Macro, Warnings and Messages.

When I type the code into (for example) A1, the Object name should
appear in B1. I have named the lookup chart "Objects" and the formula
for B1 is:

=IF(A1="","",VLOOKUP(A1, Objects, 2))

The wrong value is returned, i.e Q is typed in and Macro is returned.
What's going on?
I have attached the spreadsheet for you to look at.

Please help...

Attachment filename: lookup.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=664551

 

[Haldun Alay]

hi,

to get correct value from lookup table with your existing formula, your lookup table has to be sorted.

or if you change your formula with following one it will get correct value.

=IF(A1="","",VLOOKUP(A1, Objects, 2,FALSE))

Kind regards.

--
Haldun Alay



"MysticalNomad >" <<[email protected]>, iletide þunu yazdý I have a spreadsheet that will lookup an Object name based on the Object
code. The Object codes are Q,R,F,M,W and Msg and the Object names are
Query, Report, Form, Macro, Warnings and Messages.

When I type the code into (for example) A1, the Object name should
appear in B1. I have named the lookup chart "Objects" and the formula
for B1 is:

=IF(A1="","",VLOOKUP(A1, Objects, 2))

The wrong value is returned, i.e Q is typed in and Macro is returned.
What's going on?
I have attached the spreadsheet for you to look at.

Please help...

Attachment filename: lookup.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=664551

 

[RagDyeR]

Just add the fourth argument for an exact match:

=IF(A1="","",VLOOKUP(A1, Objects, 2,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


message I have a spreadsheet that will lookup an Object name based on the Object
code. The Object codes are Q,R,F,M,W and Msg and the Object names are
Query, Report, Form, Macro, Warnings and Messages.

When I type the code into (for example) A1, the Object name should
appear in B1. I have named the lookup chart "Objects" and the formula
for B1 is:

=IF(A1="","",VLOOKUP(A1, Objects, 2))

The wrong value is returned, i.e Q is typed in and Macro is returned.
What's going on?
I have attached the spreadsheet for you to look at.

Please help...

Attachment filename: lookup.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=664551

 

[...Patrick]

sort the table on the right bye the object (col E)


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel

 

[Arvi Laanemets]

Hi

sort the table on the right bye the object (col E)

And when an nonexisting code, p.e. 'S', is entered, an object name is
returned! Here is exact match needed, so 4th parameter must be set to
False - which makes sorting abundant.


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

--
...Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel


"MysticalNomad >" <<[email protected]> a écrit dans
le message de news:[email protected]...