Get instant live Excel expert help with VLOOKUP functions

need a formula to extract data from any with same format excel (vlookup?)

Hi, I am trying to make a control sheet where I can have all the data from data sheet into a quotation with a single vlookup lookup value but it seems every time when I apply vlookup can only bring the first value? can someone help it out? Thanks.

Hi I need help with this file. I am looking for our top selling items by Item description. We have the same item listed multiple times with different item codes. Some item codes indicate more than one quantity such as a case pack of 12. What is the most effiecient way to get an accurate quantity of the same item. We really only have about 70 real sku's, but as you can see this sheet shows about 400+. I tried VLookup, but am not really getting much help. I have created an item mapping sheet attactched in a tab.

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?

can u help me to solve the vlookup function for unit price before markup column? =vlookup(D2...?

I have written a formula combining one if statement and on if and statement, with each criteria consulting a vlookup table. My issue is when there is no value in the logical test field the value returned is the first 'value if true' result when I would like it to return n/a instead. =IF(J47<=VLOOKUP($E47,REGIONAL_Times,10),"Regional",IF(AND(J47>VLOOKUP($E47,REGIONAL_Times,10),J47<=VLOOKUP($E47,COUNTY_Times,10)),"County","N/a"))

I am trying to vlookup from one sheet to another when the source does not exactly match

I have a VLOOKUP that I would like to discount the price by 15% IF the information in another column is either A or B out of the option A B or C

vlookup help needed please help me i am speniding time

the vlookup function is not working properly and is returning wrong values when i am searching from an another file