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
trying to create a spreadsheet for invoicing purposes that uses a index match lookup function
Solved by X. C. in 11 mins
In cell B17, calculate the number of delivery days for the order. Insert an IF function that first tests whether the value in cell B16 is equal to an empty text string (""). If it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range F5:H8 using the value of cell B16 as the lookup value.
Solved by S. F. in 26 mins
Using the excel INDEX function I can lookup a row of data within a table. But could I add a second layer to this and lookup a table of data from a separate sheet with a single click?
Solved by C. S. in 30 mins
I need a lookup formula that returns a value if the cell CONTAINS a certain text
Solved by I. H. in 23 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 K. H. in 24 mins
Complete task from previous expert as we didn't have enough time to complete in one session. The task is to do vlookup on columns Y-AD in "Distribution Profile" sheet and match to "Lyngsoe Regs Export" sheet column D & E and then return earliest date and last date from column H.
Note1: "Lyngsoe Regs Export" sheet columns A-C added by previous expert to create lookup value to match data from "Distribution Profile" sheet.
Note2: Column E in "Lyngsoe Regs Export" sheet match to "Mail Center ID" sheet.
Solved by K. L. in 27 mins
I am trying to change a formula on an existing spredsheet, and it's a very simple change in a Lookup formula to change the look up range, but when I make the change, it displays the formula rather than the result
Solved by X. J. in 24 mins
Edit vlookup formula to lookup column G in "Distribution Profile" sheet and match column B&C in "Lyngsoe Regs Export" sheet and then return earliest date and last date from column F.
Solved by B. H. in 23 mins
click cell c7 and insert a lookup function that identifies the series code, compares it to the series legend, and then returns the name of the series.
Solved by A. Q. in 22 mins
Help please me with creating formulas or using v lookup
Solved by T. S. in 17 mins