Flora Edwards
asked on
Excel Formula Lookup every word in single cell and match it with another cell if found the return the next column.
hello Excel Champs,
Please see attached.
i have two table. can you help me construct a formula for Table1 so that it searches every word into the first column of TABLE2 if match found then return the Capital back to TABLE1.
EE.xlsx
Please see attached.
i have two table. can you help me construct a formula for Table1 so that it searches every word into the first column of TABLE2 if match found then return the Capital back to TABLE1.
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
EXPERT CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER