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

I'm trying to conduct a vlookup on a field (a SKU number for a product in this case) and then look through multiple (consistently formatted sheets) for that same field (i.e., the SKU number) and the most recent price it sold for. I believe this means a vlookup with an indirect formula). However, if I would like for the formula to prioritize the order in which it looks for a SKU and price-match across the "invoice" sheets, is there a way to do this?

Solved by S. Q. in 25 mins

I am trying to get a formula to work on my excel sheet so that my customers can select their custom width and height for the painting they want to purchase. I have previously had help with a Vlookup function. Now I'm trying to multiply the total sum of the equation (width + height x base $) to arrive at the total price, after apply a discount of 56% and receive the total sum the customer would need to pay.
Marked in red on the second table are the variables hights I tried to calculate.
It would be helpful to know if I can have it all in one equation, I have tried to do it but to no avail.

Solved by M. F. in 11 mins

How to compare 2 columns in excel? I am trying to use a VLOOKUP formula to reference a different sheet in my cost analysis. Can you help me?

Solved by V. F. in 14 mins

i am having trouble with vlookup formula. all most all of te samples i saw from internet have an id is there any way i could use the vlook up formula without an id

Solved by Z. B. in 19 mins

Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The IF function will include a TEXT function and a nested IF function with a VLOOKUP function.
The logical test will verify if cell G2 is greater than 0.
The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2)
The value if false will return blank.

Solved by E. A. in 13 mins

I am using vlookup formula in excel, my table reference jumps from 0 to 30 and I want my formula to pick up 24 (so nearest), but it still returns total 0. It's only picking up exact values with either TRUE or FALSE.
e.g. 0 = 0%, 29=8%, 30=10%
=VLOOKUP(H8,Table1,2,TRUE)*($D$8:$D$13) (This works for my exact values only) Why??
Please help.

Solved by K. C. in 17 mins

I need a vlookup formula to grab the specific data from specific columns from the data drop tab

Solved by C. F. in 13 mins

Hello, I would like help with TAB "Data NWA and Budget OOMs" to modify the following formula in Column M, row 34
=IFERROR(VLOOKUP($O34,'Data - Pivot Hrs Cost'!$A:$D,4,0),"")

Solved by C. H. in 26 mins

Switch to the worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country. (Be sure to use relative and absolute cell references as needed.)

Solved by S. C. in 11 mins

i had a session that produced the attached file, but the expert didn't explain a vlookup formula

Solved by V. Q. in 16 mins