lookup

  1. D

    Get last 2 non blank values of a row

    Hi, I am trying to make a column to obtain last values that were added in some table. Each month table expands so new values are added... So far, I managed to get the way to obtain last value, last value -1 and last value -2 (so I'm having last 3 values in other words). My problem comes when...
  2. D

    Place Text String to Specific Row Number Identified by Number + Match ID to Same ID Embedded in String

    I need a formula that will place a text string in a row specified by the number from an adjacent column within a look-up table. Additionally, I also need a formula that will return a text string based on the same row number described above, plus a match of the ID number with the same ID #...
  3. A

    Want to pull data by searching for the column name into another sheet

    I want to be able to drop information into sheet 1, and automatically in sheet 2 it searches for the column name and inputs the data below that? In more detail, I want to be able to drop multiple different invoices into sheet 1, the problem is they are never laid out the same. I'm hoping to...
  4. A

    How do I put the if function inside the lookup? - Daily Routine sheet

    I have a sheet - daily routine which has two columns: activity and time as shown here | Activity | Time | |----------------------|----------| | Sleep ? | 6:00 am | | Toilet ? | 6:15 am | | Get ready for gym ?‍♂️ | 6:30 am | | Exercise ? |...
  5. Jyggalag

    Make VBA code that posts a cells formula as a value

    Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...
  6. D

    VBA Lookup value in another workbook

    Hi, I'm struggling to find the way in how to use xlookup function, to obtain data from another workbook, but without using the workbook name/path. I want to avoid using the name of the workbook and the path, because its going to be changing each day both name and location, earlier in the macro...
  7. G

    Return a list based on specific values

    Hi All, I'm wanting a function to look down a list and based on certain required criteria on that lookup, return all values in a list format starting in a specified cell. So as below let's call this range A1:D5. I want the lookup to look down Column A:A searching for "Graham" and then in C1...
  8. H

    Look up a value based on header criteria - help!

    Hello, I am looking for a particular function or set of functions that will allow me to display data on a "summary" tab in excel. The context for the data that I am dealing with is listed below: I have multiple values from different regions that differ each month, what I would like to do is...
  9. S

    DAX query - Looking up (v-lookup) in the same table

    Hi All, Hoping can get some input from the DAX experts here. I have a table imported via power query. It has 2 columns Employee ID - this contains a list of employee IDs Month - this contains 'current month' and 'last month' value Note - The same employee ID can appear twice in the table...
  10. S

    Looking to find the cell returning the first number greater than 1 and return the column header for that cell

    I've got my column headers as dates Column C:N and my rows 2-3 contain the numbers. I'd like to find the cell in row 2 that first reached a number >=1 and return the date in column header. I'd like to have Column T return the column header for the cell that first meets my criteria. My formula...
  11. M

    Improve Holiday Planner by using named ranges in an array?

    I have a holiday planner to work with - not mine originally but the job do not want to make any significant changes (all "used to this one") In the range I have pasted below there are "Months" defined by merged cells. In the second xl2bb paste is the section that shows the formulas being used...
  12. MDHolmes

    Populating a wage based on a drop-down list

    I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...
  13. J

    Look up on single row set of data

    Hi, I need help with my set of data. I recently download a set of data and unfortunately, the data is in a single row per entry. I need to look up the data. Example the data is New York Apple 100 Orange 75 Grape 50 Tokyo Orange 40 Apple 30 Grape 65 Jakarta Grape 10 Apple 40 Orange 75 I...
  14. G

    Cant Find value in formuale- VBA

    I'm writing a macro to make it such that if a value is found in column B then do one thing, otherwise do another thing. However it doesn't return the correct value because it doesnt look at the the text the formulae outputs. Sub Value_Find() Dim Cell As Range Columns("B:B").Select Set Cell =...
  15. D

    Return lookup/index(match) list based on partial text - with no blanks

    Hello, I've been trying to work to get this right for a few days, but to no avail, and would appreciate help. Here is a preview of the data: A B C D E F G H I J K L M N 1 2 3 LISTS LISTS LISTS LISTS 4...
  16. G

    Use XLOOKUP to get largest hour for a given day

    Hi folks, Struggling to make the following work, mainly because the last hour is not always the same. I have 1 hour Close (col F) data for a continuous futures contract Due to when markets trade, the final hour of data is not always the same. In this case it is not always 23:00:00 time. I am...
  17. B

    How to do multiple lookups with VBA

    Hey, I have a list of products that I want to lookup against a big database of products. The difficult part is that one product can have multiple matches in the database and I need to have all matches come up in the results (unlike with vlookup). Also each product has multiple criteria that I...
  18. L

    2 Column Dropdown List That Must Match Dependent on Selection.

    Hi All, I currently have a PO tracking sheet which requires both The vendor name and vendor id to be present on the sheet for each recorded purchase order. What I am looking to accomplish is having users be able to make a selection from whichever column and have the corresponding data...
  19. Jyggalag

    How to make formula return blank value when cell is empty

    Hi all, I have the following formula: The formula checks if the value in column D is located anywhere in sheet 2's values in the array B1:D133. However, when I pull the formula down, it also checks blank cells. Is there any way to edit this formula, so when it checks a blank cell (for...
  20. U

    Return Max Value of Column X after Vlookup of Column A

    Hello, I have a workbook with 2 sheets, "ProgramMasterList" and "urslabs". I'm trying to lookup the latest Date in column M in sheet "urslabs" and match the values into sheet "ProgramMasterList" in column V using column A as the lookup value in both sheets. I'm using a vlookup to lookup the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top