if then within range

H3 =VLookup(F3,$U$3:$V$32,2,0) and drag down.

is U3 to U32 - a fixed range and set of numbers ?
And are those codes always different

I notice there are different codes for each range (assuming U3:U9 = U3:U10 )

so can you just do a simple lookup of the value

index($U$3:$U$32, match(F3,$U$3:$U$32,0))
and so you could use that as a lookup and add the prefix L, S, F, P, LC to decide on the number

is that correct or are you looking at the numbers only

IF( ISERROR(index($U$3:$U$32, match(F3,$U$3:$U$32,0)) ), "no Match", IF( left( and I can look at perhaps an array to find the value ) =LOOKUP(LEFT(F4,1),{"L","S","F","P";10,20,30,40}) )

Thanks for the rep.

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.