## Creating a (repeating?) vlookup table for raw materials

Hello. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with …

Hello. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with …

Hi I am looking for a solution to a problem in excel when trying to build a ss for a logistics company as followsIf column A has start point for a truckColumn …

=IF(SUM($K2+$N2+H2)-$M2<0,VLOOKUP($B2,’Container QTY’!$A$2:$B$219,2,FALSE),”0″) Hello – i am not sure how to …

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

i think it should be done with match vlookup and offset but its too complicated. i need to show differences between revenues of client between 2016 month five …

The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …

Hi, thank you very much for your help. I have in about 30 worksheets in 1 workbook. In each worksheet-cell B3, I have expiration dates for materials. I …

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

Hi all, I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …

Jag letar efter ett sätt att hitta ett unikt värde i en matris och sedan returnera värdet i raden under det. Column 1 Clumn 2 Column 3 Bird …

I’m doing a VLOOKUP to find a value. On the following column, I need to find the value immediately below the one that VLOOKUP got. How would I go about …

Hello, I have two Excel sheets, each one contains ID and Quantity. I want to automate the task of comparing the two quantities together for the same ID. …

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–> up front/ annually quarterly/monthly $1,000 $4,999 5% …

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

I’m wanting to add up a row of values that are pulled from a vlookup in another spreadsheet. Some of these values will result in a blank because …

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

I’m using vlookup to populate a tally spreadsheet. It is working very well when the lookup value is a regular number – like 21073 (classified …

I use a software that is online to track my companies fleet. I am creating reports in excel for things like fuel consumption. I download the spreadsheet …

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a …

Hi … using Excel 2010 I’m looking to get a sum of 5 different numbers referenced by “codes”, and wondering if there is an easy way to …

Hi guys, Really desperate for your help here. Can’t get my head around why this formula does not work. Im using excel 2002 and trying to used If with …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.