Get instant live Excel expert help with LOOKUP Function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need help trying to figure out how to use lookup in google sheets
Solved by B. H. in 14 mins
I need to import the data form the "Monthly Sales Import" using the month in C3 in Sheet 1 for every retailer. So for example if c3 is may 17 i need to lookup for this value ion other sheet and import sales volume according to the reatiler that is in the row. is it doable with function?
Solved by D. J. in 23 mins
Formula to lookup name on a specified tab and provide data
Solved by M. S. in 26 mins
I have a sheet with many locations address'. This is in column format, for example:
WBData:
D2 - Site Name
E2 - Add1
F2 - Add2
And so one to country.
I have another sheet (Location Info) with an address layout in one column:
C8 - Site Name - This is a lookup list using DataSheet A1
C9 - Add1
C10 - Add2
And so on....
Once the user selects A1 in the look list, i would like the rest of the column fields to be populated automatically from the data sheet.
Solved by I. D. in 30 mins
I need to lookup and return a value that is a hyperlink. So when lookup resolves the data returned is also in hyperlink form so I don't need to create the hyperlink all over again.
Solved by C. C. in 20 mins
In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00.
Solved by E. E. in 17 mins
I need to use a lookup function, but instead of manually entering formulas every time, i want to use the same table array that is in multiple workbooks, and use a hyperlink to define which workbook its coming from.
Solved by C. A. in 14 mins
I need to create a vlookup with a dynamic lookup range which changes each time
Solved by C. H. in 14 mins
I have two different tables queries pulling in from external data sources that update regularly. The both have the same unique identifier that I am able to use lookup functions to specific columns together.
The problem I am having
On the main spreadsheet the unique identifier is only listed once but on the other is listed multiple times based on dispense or order date with corresponding notes. I need the table with multiple entries for the same unique "customer" record to automatically filter by the most recent date entry as it the external data sources pull in new data.
How can I do this?
Solved by T. U. in 26 mins
I need to use INDEX MATCH or some other lookup formula to return data from a raw data table into an organized sheet in the same workbook.
Solved by B. C. in 18 mins