Line Description-Located on 1st Worksheet
Expense Type - Located on 1st Worksheet
Vendor Name - Located on 2nd Worksheet
Type - Located on 2nd Worksheet
|AMEX Reclass - 35965 (these number change)||Results goes from column D ||AAA-AAA||Taxes|
|BBB-BBB||The result would be Earnings from Column D||BBB-BBB||Earnings|
|AMEX Reclass - 35784 (These numbers change)||The result would be Award from column D||AMEX RECLASS||Award|
|AMEX - 57896 (These numbers change)|
|AAA-AAA|| The result would be Taxes from Column D|
Column C and D is a table in separate worksheet from columns A and B. I need an index match to search column C and the corresponding row from Column D in Column B of the first worksheet. There isn't an exact match between column A and C so I think I need a wildcard.
Hopefully this makes sense.