vlookup help

[mangesh]

hi
i am providing you with my problem with attached file.
i will be very grateful to you if you can solve my probem

Attachment filename: help me.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46482

 

[Frank Kabel]

Hi
first: you should try to explain your problem in plain text. Most
people won't open attachments

To your problems: Just enter the 4th parameter of the VLOOKUP function
to look for exact matches. So change
=VLOOKUP(A17,A25:C27,3)
to
=VLOOKUP(A17,A25:C27,3,0)

and
=VLOOKUP(A17,A25:C27,2)
to
=VLOOKUP(A17,A25:C27,2,0)

 

[L. Howard Kittle]

Hi Mangesh,

The code in cell can be changed to this to do what you want.

=IF(ISNA(VLOOKUP(A17,A25:C27,3,0)),"No such code",VLOOKUP(A17,A25:C27,3,0))

HTH
Regards,
Howard

 

[L. Howard Kittle]

I should say the FORMULA, not CODE.

LHK

Hi Mangesh,

The code in cell can be changed to this to do what you want.

=IF(ISNA(VLOOKUP(A17,A25:C27,3,0)),"No such code",VLOOKUP(A17,A25:C27,3,0))

HTH
Regards,
Howard