vlookup

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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

Try this formula..

ColA = Table of numbers
B1 = Query number
C1 = formula

=IF(ISNA(MATCH(B1 &
"P",$A$1:$A$10,0))=TRUE,IF(ISNA(MATCH(B1,$A$1:$A$10,0))=TRUE,"","m"),"p")

If this helps click Yes
 
Back
Top