hlookup

Hi Guys, I have a HLOOKUP formula that looks at a table on a separate tab. I have 2 further tables in the same format but both on different tabs which I also want the formula to read. Basically the lookup value element of the formula contains all of the possibilities within those 3 seperate...

This is my formula that looks at the date then goes to the tab named events check dates and if date matches it posts the information back at the first page. =VLOOKUP(B3,event,8,0) The problem is if I have items in columns 2,3, 4, 5 etc vlookup ignores these columns. I need the formula to do as...

Hello, My file has company codes(CoCd) in col's and Profit centers(PC) in rows, with $'s assigned to them. I need to retrieve $'s specific to a PC and CoCd combination. Issue is sometimes same CoCds are in multiple columns. So can't do a simple sumif or Hlookup. E.g. B30 PC0001 B31 PC0002 B32...

Hi, I have a project I am working on where I am trying to find a max value in a row and then insert that max value into its own column and then next to that column create a new one that returns the date that the value occurred on. Any suggestions or functions for how I could find that date? I...

<tbody> SKU# 2301 2301 2301 50010 5000 50010 $ Units Stores $ Units Stores 1 23 3 50 15 2 48 2 6.99 1 50 17 2 48 3 30 6 50 6 1 48 4 0 0 50 15 2 48 5 100 20 50 15 2 48 6 72.32 15 50 7 1 48 7 6.99 1 50 18 2 48 8...

How would I code an array to do a kind of hlookup? I have data on sheet1 in columns A:I. I have data on sheet2 in column A. I want to look at the value on sheet2 row A and see if it is listed in the data on sheet1 columns A:I. If it is, i want the value from row 3 of the column it's in on...

I need help to figure out how to best do this. Tried to search it and didn't see anything that works exactly. Here is what I want to do. I want to vlookup/or hlookup into a different sheet (Bottom table is what that sheet should look like) where the value is in different column and rows and...

I'm tryin to return a value above the searched row. I've tried a couple options and here is what I have tried: =HLOOKUP(LEFT(Y4, 4), CHOOSE({1;2},B3:M3,B1:M1), 2, FALSE) =INDEX(A1:M3,MATCH(LEFT(Y5,4),A1:M3,0),MATCH(LEFT(Y5,4),A1:M3,0)) =VLOOKUP("AISLE", A1:M3, MATCH(LEFT(Y6, 4), A1:M3, 0)...

Hi Id be grateful for some help with a hlookup formula which is supposed to return the value, but also any hyperlink associated with that value The formula is as follows =HYPERLINK(hlookup(C$1,Master!$C$1:$BM$150,ROW(),FALSE)),"") but the error is 'Cannot open the specified file' I've...

Hi I have a problem trying to use a column number in the formula below. HLOOKUP(N1,A1:A&INDIRECT(Q1),2) There is a column number that will appear in cell Q1 and I want the lookup range to work based on that, for example if there was an 8 in cell Q1, then Excel would read the Hlookup as...

I'm trying to add to spreadsheet I made a couple of years ago. I need to tweak a formula to put something similar-ish in another cell. I know what the formula ends up producing but can't remember how it works. Can anyone translate each of the steps in this for me please...

Hi, I am trying to highlight a cell Q11. I want it to Hlookup cell Q5 in Columns BV:BX and then if Cell Q11 is greater than the Hlookup for it to highlight Cell Q11 in Green. I hope this is clear. Thanks for your help Dan

Hi, I'm trying to lookup a value in a named table (Zoo), then search horizontally for the first match or if there is no match, the next greater number, and return the header. Values in the columns will always increase from left to right. Example: Sam 7 Result: monkey Example: Sue 9 Result...

How do I SUM values where one criteria is on vertical axis then the another criteria is on the horizontal axis? I.E, if I wanted to sum the BEACH for June only <tbody> MONTH WEEK BEACH DENIM DRESSES JERSEY KNITWEAR NIGHTWEAR OUTERWEAR SHIRTS SHORTS JUNE 1 0 2 1 1 1 1 1 1 1 JUNE 2 255 382...

Hi guys, I dont think this one is difficult, but I cannot find a good solution :) Maybe one of you can help :) I have a big table: <tbody> A B C D E String String STring String String String STring STring String STring String String String String String String STring String String...

Wondering if someone out there can help me with a crazy formula needed. What I am trying to do: In J, Find the audit date in A2 within c1, d1, e1, etc. Starting with that found amount, has the amounts after steadily increased? What percentage over the average inventory has the store increased...

Hi All, Need help with 2 formulas, kind of related as both need a HLOOKUP start range and 'last blank cell in row' as end range (i believe), any help will be greatly appreciated....... In column M (M2:M5) i need a formula along the lines of...

Sheet1 <tbody> 2019 2020 1234 54 66 5678 14 44 </tbody> Sheet2 <tbody> 2019 2019 2019 Result Flag Result 1234 54 51 77 5678 14 28 101 </tbody> =HLOOKUP(B$1,Sheet2!$A$1:$Y$4,MATCH($A2,Sheet2!$A$1:$A$4,FALSE),FALSE) Hi, Above you can see a shortened...

Many time user....first time poster :) I am looking to return a column value from a single row based on two variable (one in rows and one in columns). Hopefully it makes more sense in the table! I have 'over engineered' a solution but hoping for something more streamlined to save workbook bulk...

Hi all, I am trying to write a formula where I can put start with the data in Table 1 and then write a formula in column B of Table 2 to pull in the correct ID numbers from Table 1. Essentially I want to do a VLOOKUP, but I need the VLOOKUP to pull in the data from all rows that meet the...