I have two tabs in workbook
1. Vendors Found
2. Consolidated List
I need a formulae which looks for "vendors found values" in "consolidated List" if found place the corresponding column values in Consolidated list tab.
Vendors name will be found anywhere in the Merchant description tab.
Your help in this regard is much appreciated.