lookup

  1. k3yn0t3

    INDEX(MATCH()) pulling wrong row data & Macro to duplicate sheets with formulas

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

    Lookup specific values that occur in sequence

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

    AWG Wire Gauge lookup table

    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 =...
  4. D

    Which box for which parts?

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

    Get Last Matching Date

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

    Lookup value within range

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

    Replacing Nested IFS with LOOKUP

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

    Binary search and return all matches as an array

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

    Return column header for highest, 2nd highest, 3rd highest etc value

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

    Which lookup do I need? And how do I use it?

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

    Need Help in lookup value with multiple criteria

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

    Lookup Data with Ignoring Blank rows

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

    Lookup across worksheets with variable rightmost cell in each not working

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

    Device ID Lookup through VBA

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

    Index-match or lookup, or? extract multiple data from array

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

    Lookup participants and time of meetings to create an automatic calendar schedule

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

    How to complete XLOOKUP across a row but have the lookup array change dynamically by column in another table

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

    IF formula Help

    I am trying to lookup only "DELIVERED" items and have it look up based on tracking number, then return the date it was delivered from Sheet 2 Col L to Sheet 1 Col J, but ONLY if Sheet 1, Col C status says DELIVERED, otherwise leave blank not some error code like Ref# or something else. Also, how...
  19. V

    Using UDF on multiple sheets causes #NAME? error

    Hi, I need some help with the following. I have two workbooks where I need to do a lookup in between and obtain a value. To be more precise there is one active mastersheet which contains all the data, and a map with separate sheets, and each sheet does a lookup on the mastersheet and obtain a...
  20. A

    Lookup and match multiple values separated by commas in a cell and produce matched value

    C2:C7 has single non-sequential numbers and B2:B7 has multiple numbers separated by commas in each cell. I want to match the C2 numbers in B2:B7 and get the output of the corresponding matching number in D2. Can anyone help me formulate this? Thanks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top