Get instant live expert help on vlookup range lookup
“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
can you explain why in the sales worksheet, vlookup function in column E range lookup is 0 while in column H the range lookup is true. what's the difference?
Solved by X. D. in 22 mins
I need to create a vlookup with a dynamic lookup range which changes each time
Solved by C. H. in 14 mins
Hi, Could you explain this into plain english please?
=IF(AND($AY6552="SO",VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)=3.06),"Bolt On",IF(AND($AY6552="SO",VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)<>3.06),VLOOKUP((VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)),'Product List'!$N:$U,8,0),VLOOKUP((VLOOKUP($A6552,'Priority Lookup'!$A:$C,3,0)),'Product List'!$O:$U,7,0)))
Solved by V. E. in 14 mins
VLOOKUP function to display the number of calories in the selected boxed set. Use the boxed set listed in cell I5 as the lookup value, the range A14:D17 as the table array, column number 2 as the column index number, and FALSE as the range lookup value. Useabs in excel cell I5 and the range A14:D17.
Solved by X. S. in 16 mins
the below code now only allows me to enter a sku with a letter in front of sku - K123456. some of my skus just have numbers - 481181. how do i alter code to accept both ?
.Reg3 = Application.WorksheetFunction.VLookup(Me.Reg2, Sheet2.Range("Lookup"), 2, 0)
.Reg4 = Application.WorksheetFunction.VLookup(Me.Reg2, Sheet2.Range("Lookup"), 3, 0)
.Reg5 = Application.WorksheetFunction.VLookup(Me.Reg2, Sheet2.Range("Lookup"), 4, 0)
.Reg6 = Application.WorksheetFunction.VLookup(Me.Reg2, Sheet2.Range("Lookup"), 5, 0)
.Reg7 = Application.WorksheetFunction.VLookup(Me.Reg2, Sheet2.Range("Lookup"), 6, 0)
Solved by B. W. in 13 mins