lookup

Hey everyone, I have struggling with this for days now...and my team is depending on me to figure this out soon. I need help with doing some sort of lookup on data that is in different columns below a merged header cell. I need a specific cell to be chosen based on the name that I input. For...

I have a dataset shown below that is used for production scheduling. I would like to be able to look up by the bay number and the date and return the job # and the phase that the date falls in. If I reorganize the data, I can use an index match and concatenate function. However, the scheduler...

Hi, I need a count formula that counts names across multiple columns. I need to know how many people attended Philadephia. The answer is 5. Then pull the formal down to know how many attended Orlando = 6. please note the blank cells are blank b/c there is a formula iferror return "" A1 first...

Hi, I have a formula that looks up the last value in a range. This formula is =LOOKUP(2,1/(L2:BI2<>""),L2:BI2) I would like another formula to look up the 2nd last value in a range. Could someone supply this for me please? Thanks in advance

I have the following formula =LOOKUP(DATEDIF(AE4,NOW(),"Y"),{0,4;1,4;2,4;3,6;15,8}) to determine how much leave someone earns based off the years they have worked and when the person is only earning 6 hours, i need to add 4 hours to the last week of the year. How can I do this? Do I need to...

Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...

Hello Everyone! I desperately need your help! I need a code to do the following: sheet "template": column a must always have a numeric value. column b must always have alphabetic value. sheet "colors": column A and B will have the values as needed. For example 100 is Black, 200 is Blue etc. Any...

Hi, Firstly, thanks for taking the time. I am extremely new to Access, so hopefully this makes some sense. I have a table with some address details and I want to generate a Unique ID (either in the ID field or a new field) which relates back to the initials entered into the "State" field...

How can I reference a worksheet name from a cell found from a lookup function? For example, xlookup searches within worksheet 1, 2, and 3 for value. If value is found in worksheet 3, I want it to return "C", if value is found in worksheet 2, I want it to return "B" and so forth.

Hi there, I was given the task to force balance the data in 'Q1_2024_Raw' to sum to the final total by GEO (i.e. all LATAM customers need to sum to 10, so in this case I need to force balance their data down from 20 to 10 and all NAAM customers need to sum to 100 so I need to force balance up...

The lookup formula is giving wrong answer only fir the last row. In the example photo given, I want to search for fruits given as reference from one column into other column and output the price. All other answers are correct. But only last row gives wrong answer. Can someone please help? It...

Hi all, My skill in translating logic into a formula and especially VBA is very limited. Hopefully the below makes sense. Basically I was hoping for a VBA code that pulls through results on to a new sheet by using the reference column A (Order Ref) in Sheet 2 and comparing columns of the...

Hi all, I have the below code, currently I have hard coded the email to address but I have a list on a "Variables" tab, range J2:K10 (also below) with where the report should go. Rather than updating the code, I was wondering if I could lookup to this list and return the right to person...

What I am ideally trying to do is to build a dropdown off D2:I2 (day #s). I know how to do that, but I want to build the drop down on another tab and have it bring back the data in columns A:C. I need to be able to filter on the day # and have it return Name, Date, and Qty, but only if the day...

Hi everyone. I have two sheets: (A) master sheet and (B) single store sheet (examples below). I'd greatly appreciate your help with two things: A Formula that dynamically populates rows 2-15 of Col B on "Store 1 Sheet" I tried this but it's off by one row... I think it's treating the "Store...

In a data set, I'm trying to identify a way to lookup the first instance of a transaction type and its corresponding date and the first instance of a second transaction type (and corresponding date) that occurs after the first transaction type. In the enclosed example (click on image), in the...

I'm trying to convert AWG wire gauges to mm2 to check if a wire fits in a wire range. I'm using a lookup table where I've manually populated 14-1000 MCM wires to mm2. My VBA is working on everything except "1/0" - it's working fine on 2/0, 3/0, and 4/0 Here's where it breaks: conv_AWG =...

Hi everyone hopefully you can help me out with this as my head if fried. I have had a look at some of the other answers for similar questions but I can't see how they would work for my problem. I have a long list of parts in my inventory. I also have a list of boxes for storing the parts. I...

I have searched through many sites looking for what seems to me to be a very simple answer but nothing seems to work. This is a bogus workbook that somewhat matches a confidential workbook, thus the fictitious amounts. In column B you see text from a legend that indicates a specific activity. In...

I have data table which has [Sub-Cat ID]. Another mapping table has [Category ID] [Category Name] [Sub-Cat Start] [Sub-Cat End] I want to insert a new column in the data table which will lookup the corresponding [Category ID] for each [Sub-Cat ID] where [Sub-Cat ID] >= [Sub-Cat Start] AND...