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??
|