Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default vlookup

I am looking for a way to develop a program that will do the following.

Lookup a number from a table and then display the proper responses.

example...I am looking for number 30013-871

In the table there are two entries:
30013-871 = M
30013-871p = P

I want the program to recognize if there is the number that I am looking for
plus a "P" on it, and display "P". If it's only the number without the P, I
want it to display "M".

Can anyone help with this??