column matching

Hello Wizards of Excel, I'm in a bit of a bind I'm trying to find a partial match within a list of keywords. I'm looking for the return result to be the word found in the list. I tried vloookup and index match, but the problem is that it only finds the exact match of the word and doesn't take...

Hello, I have two excel sheets with two column names (email, status) on both. I want to update status column on second sheet with status columns on first sheet(only if e-mail matches on both). Please help in writing a formula for same.

Hello, I am trying to match Phone numbers from Customers sheet to the records in Calls_Logs sheet. I want the name in Call Logs sheet to get updated according to matching phone number. I have close to 300000 records so it is impossible for me to do it manually. I tried using this code...

Hi guys, I'm having trouble getting 2 formulas right the first one should be easy... cust no | Customer --------------+--- ----------- blank cell1 - Customer Name 1 blank cell2 - Customer Name 2 I have 2 sheets one has empty customer number fields next to 645 customer names...