vlookup 2 conditions

I am trying to lookup grand totals depending on Origin and Metalane. I have two sheets. This is the reference table: <tbody>#E0E0F0[/URL] "] #FFFFFF[/URL] ]A #FFFFFF[/URL] ]B #FFFFFF[/URL] ]C #FFFFFF[/URL] ]D #FFFFFF[/URL] ]E #FFFFFF[/URL] ]F #FFFFFF[/URL] ]G #FFFFFF[/URL] ]H...

Hi, Hope someone can help. Going round in circles trying to work out how to do a lookup with multiple conditions. Trying to lookup using the customer CGLE300 (H1) to return Description in column F if the ACCT. is 1000 (H2) and the Status is "Final" (H3). Think i should be using vlookup and...

I am trying to use a Range VLOOKUP based upon the criteria of color in this example. I have another set of data but used this example for simplicity and business reasons. But I need to use the table range that corresponds with the color. I have a lot of values so hard coding is not an option...

Hey Guys, Desperately need some help here. I have a column where I need to - lookup a date and see if it falls in-between two dates displayed on another sheet - Make sure the dates it is looking up are for the correct advertiser What I need it to return is either 'Active" or "Previous IO" if...

Hi there, I am trying to get a cell to vlookup from two different columns of one table dependent on the result of a different cell. For example, if the 'total spaces required' (AB4) equals 3 or less, then it needs to look up in column 2 of the postcode table (psc_items), if it's more than 3...

Hi All, I have a spreadsheet that will eventually contain a lot of data and I want to be able to use formulas and data validation to populate that data onto another sheet by date. I can't use the filter tool in my case. On the sheet with all the data column A has a timestamp formula...

I am trying to compare current and history data to find out if number field is matching. Currently, there are columns A through AM. However, the combination of S, T, U columns makes a unique row. So I want to compare that combination to sheet2(history data) to find out if column Z is matching to...

<tbody> Cubic Local $ Outer Area $ ShortHaul $ Longhaul $ InterIsland $ 0.003 2.00 4.00 6.00 8.00 10.00 0.005 2.20 4.40 6.60 8.80 11.00 0.008 2.40 4.80 7.20 9.60 12.00 0.01 2.60 5.20 7.80 10.40 13.00 0.012 2.80 5.60 8.40 11.20 14.00 0.016 3.00 6.00 9.00 12.00 15.00 0.02 3.20 6.40...

I want to match the (Sheet1) clent /group to the (LookupTable)name /group and return the corresponding retention. Formula i am using in Sheet1 cell-Retention Policy but is returning the wrong retention because I have multiple instances of the client/ name...

I am building a report which needs to display all entries on a separate sheet where the entry falls into a date range. Sheet1 (report) The start date is in B3. End date is in D3. Sheet2 (data) Dates are displayed in column B. Array to pull is Column B through AU. So, if the start date is...

hi there could someone help me with this problem I want to search per column in tab Supply & demand as below - for values less than 0 output should be project and role then use this output as input into Supply tab as below and search each col (week) for match and output name of resource.. is...

Hello, I need to do a Vlookup using criteria from the columns and rows. For example: <tbody> ID/CLASS APPLE BOY CAT DOG EGG FAN GUN HORN INK 1243 5,600 765 1,123 1445 2,434 112 445 9,400 2,454 3243 3,001 223 7,210 222 30 2112 3,233 211 448 101 2,444 6756 9,312...

Hi, I have data in column L3 to L26 this is my look up value. My table array is is from A3:I112. The data in the table array is grouped by week day. Coulmn A in the table array shows the days Monday, Tuesday......etc. Column B in the table array is the same data in Column L3. What do I need...

I am having troubles with my =Vlookup function.. I am using for horse racing, as an entry form. I am wanting there to be a main entry page, and then from there, it sorts all of the horse/riders into their appropriate class. I have about 10 different pages to my workbook. The first page, is...

Hi, I have 2 sheets as below Sheet 1 <tbody> <tbody> empid </tbody> <tbody> dependent_name </tbody> <tbody> relation_with_self </tbody> <tbody> dep_id </tbody> <tbody> 40100317 </tbody> <tbody> Kanhaiya Lal Srivastava </tbody> <tbody> FATHER </tbody> <tbody> 161532...

Hello. I am using Windows 7 and Excel 2007. I want to see results if the alpha-numeric value of column B appears in column A of Sheet3. The result I am looking for is a date value from Sheet3 listed in column W corresponding to the row matching the value in the current sheet's column B. If...

I have a range of cells in a column that contain the text "In Process" and "Completed". I want to search or vlookup the cells and return "In Process" if any of the cells in the range indicate "In Process". If all of the cells indicate "Completed" I would like to return the value "Completed"...

Hi everyone, I hope you could help me out with this question: I would like to have the formula to insert in the cell F2, F3 and F4. If the date in cell E2 is between dates in A and B column should retrieve the right value/text in column C (to cell F2). The same for dates in cell E3, E4 and E5...

Hi everyone, I hope you could help me out with this question: I would like to have the formula to insert in the cell F2, F3 and F4. If the date in cell E2 is between dates in A and B column should retrieve the right value/text in column C (to cell F2). The same for dates in cell E3, E4 and E5...

First time I have been in a forum and not very experienced with excel, sorry in advance of any errors I make. Goggle has got me this far but I am stuck. I am trying to create a stock trading journal that has some calculations in it. I am sure it's no work of art but again, not even basic...