Get instant live Excel expert help with VLOOKUP formula
“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 to add into my formula:
IF(AND(L13>=20.1,L13<30),VLOOKUP(L11,'2'!A2:J7,8,FALSE)*L13 BUT if the answer is higher than the value in Column I, show that value
Solved by E. D. in 25 mins
I am using a VLOOKUP formula on excel to pull live data for my job. However, after typing in the formula correctly, it isn't populating the correct value. Instead, it's giving me "0" values all the way across.
Solved by F. A. in 27 mins
Trying to make a small adjustment to an existing Vlookup formula
Solved by G. Q. in 19 mins
I want a VLookup formula that delivers "Duplicate or No" in column C if Column B is also in A
Solved by T. L. in 28 mins
my working formula is =IF(K15<=201,VLOOKUP(K12,'CHANGED RATES'!A1:H38,5,FALSE)*K15+130)
if K15 is 100 and the Vlookup is 6.01 i want the answer to be 731 /0.7 = 1044.29.
Solved by X. Y. in 12 mins
Hello !
I'm doing a Vlookup on a Spreadsheet :
=vlookup(B2;Magento!$A$1:$D$700;3;TRUE)
I'm looking for B2 on the sheet named "Magento" in the table From A1 to D700.
The value is present on D180 but the formula is showing me : N/A
Solved by F. D. in 20 mins
I need help in IF formula as well as Vlookup for which I am trying to figure out the solution but not getting through.
Solved by E. C. in 17 mins
have a problem with vlookup, I think I am writing the formula correctly, but for some reason I get N/A
Solved by C. U. in 13 mins
vlookup formula provided earlier on this site does not work
Solved by B. S. in 17 mins
My columns in L2 & M2 are not calculating to the vlookup formula as well as O2 and P2
Solved by M. J. in 27 mins