Hi Friends,

I need help in building a lookup formula (index match)

issue here is the look up values are different in formats in source table and output table

see attached please. Without changing formats in either source table or output table, can we get a straight formula that can automatically pick up uneven formats

thanks