Lookup from a delimited field

Pete, what if column E - F has over 200 rows to look upon, is there an easier way of doing this rather than writing a massive formula?

Originally Posted by djfatboyfats

Pete, what if column E - F has over 200 rows to look upon ...

You just need to change the range of the table in the VLOOKUP terms, i.e. $E$1:$F$4 could become $E$1:$F$250

If you mean that you might have more strings of numbers in cell A1 then I think it would need another approach.

Pete

Hi Pete, I changed it to 250 but it's still not working. It is also picking up the 10 as a 1 (see below)

Attachment 740438