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
Please help with rank excel formula with duplicates. A ranking formula I'm using does not rank a column of figures correctly if there are duplicate values. On the sheet labelled "Movers", column AE30 to AE44 is an example of the problem. The subsequent data being pulled via lookup in columns J30-44 and K30-44 then doesn't display correctly.
Solved by I. Y. in 24 mins
Can you help me to create a formula that will lookup the shift sched & credited hours of each employee?
Solved by X. J. in 22 mins
Hello
I am looking to use VLOOKUP to return certain column data out of an array.
Outside of a table this is what I have been using:
=VLOOKUP($B2,Sheet2!($A$8:$H$48,Column(B8),FALSE) and then dragged the formula across and down the page. This is fine, as the lookup locks to B.
However, when in a table with named ranges, I cannot drag the formula across as the initial reference keep changing as I drag across.
=VLOOKUP([@sampleid],[Book1]Sheet1!$A$8:$H$48,COLUMN(B8),FALSE)
The initial [@sampleid] needs to be locked, I assumed with $ but nowhere i put it allows the formula to function...
how do I lock this reference in a table?
Solved by S. Y. in 18 mins
im looking to hide a v lookup table and move a pivot table
Solved by X. J. in 30 mins
I want to lookup the price of my products from vertical position into horizontal position?
Solved by F. J. in 22 mins
6. On the Sales Sheet (It is blank). Create a lookup table. In the first column there should be the values to setup the different categories based on Total Sales. Anything less than $3000 is considered Low Sales. Anything greater than $3000 but less than $7000 is considered OK Sales. Anything greater than $7000 but less than $11000 is considered Average Sales. Anything greater than $11000 but less than $15000 is considered Above Average Sales. Anything Greater than $15000 is considered Excellent Sales.
Solved by A. S. in 26 mins
I am working on double vlookup function, please help advise on the case!
Solved by D. H. in 13 mins
I am attempting to v lookup and I am having problems
Solved by T. J. in 11 mins
need help with an index match excel formula, or other lookup formula
Solved by F. D. in 24 mins
I need to create a VBA code for a button that will calculate/return a lookup of multiple items with same criteria.
Solved by C. Q. in 18 mins