Multiple Results with simple criteria? [Closed]

Report
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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!

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!