Lookup of sorts

  • Thread starter Thread starter lehigh
  • Start date Start date
L

lehigh

Hi All

I asked this question a few months ago and did not understand the
answer. I'd like to try again.

$A$4 contains a string of letter codes as follows

A, B, H, S1, T, T1, T2, V, W, Z

C4 thru C20 may contain 1, 2, 3, 4 or none of these letter codes.

I would like B4 thru B20 to try to match any code in A4 with a code in
C4 Thru C20 with a text "YES","NO"

I hope this is clear enough

Thanks for your help

Tom Snyder
 
Hi Tom,

If you enter the codes in A4 in separate cells - row or column - it is quite
easy to a lookup from the values in C4:C20.
You have VLOOKUP, HLOOKUP, LOOKUP and maybe more to play with (see Excel Help on
these functions).

Regards
Anders Silvén
 
Back
Top