lookup

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...

Dear All, I have an issue. I have a table that contain salesmen, selling channel, and their achievement. I'd like to fill the incentive column using formula but I don't want to use nested If. I'd like to use lookup table instead. Here is my incentive table Name Channel % Ach. Incentive...

The last argument in XLOOKUP allows performing a binary search but XLOOKUP only returns one match. IF(value=lookup_array,return_array,"") returns all matches in an array but is slow on large lookup ranges/does not do a binary search. Would anyone know a fomula - or combination of - that both...

I have a dataset (reduced mock version below). What I'm trying to do is return the column head for the highest count for site. As an example, Site 1 has the highest count of 15.455, so I'd like Type A returned. The 2nd highest value for Site 1 is 9,708 and this would return Type E. I have...

I have a spreadsheet with 30+ tabs. All tabs have the same columnar setup I need to pull out all rows across all tabs which contain a single value found in a column cell (in this case; column C) Ideally, the report should include the tab name Some customer order numbers exist over different tabs...

HI Team, Need help in attached sheet for looking up value from table with multiple createria which includes 3 column lookup for 2 input and need result from another column with matched createria. Please help. In attached sheet Need D column output by checking G column and H column price...

it has been explained through pictures, how to fiks this problem ? thanks :)

Hi, I am using a formula as follows to pull out the rightmost result in the second row in the column range F to Z: =LOOKUP(2,1/('ABC1'!F2:Z2<>""),'ABC1'!F2:Z2) This works as expected, but I have a number of worksheets, and I'm looking to pull out the rightmost result in the second row in the...

Hey Team, Device ID is not one of the Environ Variables Excel can access. Does anyone know how to lookup the Device ID of the computer you are currently working on using Excel VBA? I can find this variable myself by going to the about section in settings. however I am looking to reference this...

Hi there, I am trying to automate a meeting planner. I have meetings down the rows, employee participants and time of meetings along the columns and market with "x" in the cells. I would now like excel to automatically populate a new "calendar overview"-table with the times down the rows...

I am making a meeting overview of an event. I create each meeting down the rows and mark an "x" under each participant and time of the meeting (both along the columns). Hereafter I would like to make separate cellar overview where it automatically marks "free", "booked" or "double-booked" for...

For example: let's say I have a six-sided die with sides A through F. I roll the die four times and record results per trial as follows: Trial Roll 1 Roll 2 Roll 3 Roll 4 1 A B C D 2 E F A B 3 E D C F Now I have another table where I want to output the roll during which each letter...