“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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