For example, the AF20 could be AF99 or AF10. Normally with a string, you could use something like: "VLOOKUP(DATA!AN2, DATA!AA9:AF" ...
www.google.com.tw