Get instant live Excel expert help with LOOKUP Function

I need a solution on vlookup. I am using vlookup for simple phrases lookup A1 in B1 . However when i want to search for a specific word in a sentence within a sell then use vlookup for that word in another cell. I have no idea how to do that.

Hi, I would like a formual to bring back results horizonally please. Ie, you will lookup B2 in sheet2, then drag the formula to the right of the spreadsheet and return the values from the tab "export worksheet" where it will lookup J2 and bring the back all the data on K2.

I need a formula to lookup value from 3 separate columns and input answer into a cell

I need to extract a unique list from a lookup value that HAS duplicates and i need the extracted values to have no duplicates

I need a column to be automatically filled in with a lookup function based on a value in the previous column.

I need a formula to lookup a price from 1 tab and enter it on another tab

I need help with a lookup formula. looking up data from a tab and inserting it in a formula on a different tab in the worksheet

I need help summing and multiplying a vertical lookup function

Task 1: Find "Glass" from column A, and lookup the most recent date for "Glass" from column B, and put it into the Cell F3. (10/8/2018) Task 2: Find "Glass" from column A, and lookup the maximum number for "Glass" from column C, and put it into the Cell G3. (1)

In column M on the worksheet ‘Purchase Invoices’ use an appropriate lookup function based on the description, together with an appropriate logical formula to show whether the supplier for each invoice is on the approved supplier list. The approved supplier list is shown by product on the worksheet named ‘Approved supplier by product’. If the supplier is on the list, then show ‘YES’ if not, then show ‘NO’ in column M.