im trying to pull the rate from column N and display the rate on column but im testing two different formuls, one using the ID and one using the Desc, The valuse in J-N is much larger in volume but just pulled those two. Is there a way to use a combination of the two ID and Desc or perhaps use only a partial string to match or why the ID wont match because there are alphanumeric values(i think)? The ID is unique to each Desc. by the way however some have alphanumeric characters. Thank you for all and any input/help!
=VLOOKUP("*"&A2&"*",J2:N3,5,FALSE)
=VLOOKUP("*"&A3&"*",L2:N3,3,FALSE)
=VLOOKUP("*"&A5&"*",J2:N3,5,FALSE)
=VLOOKUP("*"&B6&"*",L2:N3,3,FALSE)
<tbody>
</tbody><colgroup><col><col><col span="13"></colgroup>
=VLOOKUP("*"&A2&"*",J2:N3,5,FALSE)
=VLOOKUP("*"&A3&"*",L2:N3,3,FALSE)
=VLOOKUP("*"&A5&"*",J2:N3,5,FALSE)
=VLOOKUP("*"&B6&"*",L2:N3,3,FALSE)
ID | Desc | Fee | MISC 1 | MISC 2 | MISC 3 | MISC 4 | Rate | ID | CARD TYPE | DESC | Rate | |||
1L5 | L5 US REG | 0.72 | 0 | 2 | 550 | 0.72 | 0.05% | 1L5 | Visa | US REG | 0.05% | $ 0.22 | ||
1L5 | L5 US REG | 0.72 | 0 | 2 | 550 | 0.72 | #N/A | 220 | MasterCard | INTL CORPORATE | 2.00% | $0.00 | ||
220 | INTL CORPORATE | 0 | 0 | 0 | 0 | 0 | #N/A | |||||||
220 | INTL CORPORATE | 0 | 0 | 0 | 0 | 0 | 2.00% |
<tbody>
</tbody><colgroup><col><col><col span="13"></colgroup>