Multiple Results with simple criteria?

Closed
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014 - May 1, 2014 at 03:02 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 1, 2014 at 03:46 PM
Hello! Here's what Tab A looks like:


Cap Type

220 N 3993SNB34
180 N 7113038KH34/32
220 N WS450BKXL
100 N ED303BK38/32
180 N 874OG36/32
100 N 1993SNB33/30
180 N EU225WH34/32
160 N WL574NVXTL


And here's Tab B:

Cap

45 2112272BK30/30
45 2112272BK30/32
45 2112272BK30UL
45 2112272BK31/34
47.5 2112272BK31UL
45 2112272BK32/30
90 2112272BK32/32
45 2112272BK32/34


I would like a formula that says if the numbers match, return the certain type letter. There are 4 different "Types" (C,F,N,R). Thanks for your help!
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 1, 2014 at 03:46 PM
Kaiwalls04, Good afternoon.

Sorry, but your question is not clear.
Which number must match?

Please, be clear and give us some example about what you have and what you expect to have as a result.
0