Need to do a VLOOKUP and have it look for the 2nd digit from the left
in a cells contents, and find this value in a table,a and return a
result.

iow: If the cells contents are 2B75478A3, it would look for the "B" in
the table; other variations would have the formula look for the 3rd
character from the left or 7.

Table would be B2:G20, column would be 4




TIA for thoughts.

Pierre