lookup

  1. I

    Employee/Candidate <> Role/Company Match

    Hi guys, In the last few days I've been doing an internal assessment of the skills needed by certain companies that we working for, but also the skills that my employees have. With that, I started to create a kind of database in which: the first sheet has the necessary technologies to ensure in...
  2. A

    Return unique values from large dataset

    Hello, Long time reader, first time poster. I have a large dataset of relationships between "C Items" and "R Items". For a given "C Item" I would like to return each associated unique "R Item" only one time. Some "C Items" may have only one "R Item" and others may have fifty. I've included...
  3. R

    Need Help - Lookup Specific Value In a List

    Hi Friends, I need your help to lookup and find out a specific value from a list. I am using office 365 and below provided a sample data of my requirement. CategoryStatusCategoryResult for NewDataOldDataYesDataNewStyleNoDataExistingStyleExistingStyleOldStyleRejected I need to check whether...
  4. G

    Lookup column header based on row and table data

    Hello - looking for an Excel whizz. Trying to complete Cell J3 with a column header based on the player and their 'score' from the week. I have tried a combination of LOOKUP with INDEX MATCH but not quite getting it. Any help would be much appreciated. Many thanks!
  5. P

    Formula to lookup values from two tables and combine to a third table IF value is column is not empty and duplicate

    Hi, I have two PowerPivot table that I want to combine and copy information to a third table, however the search criteria is empty as the two PowerPivot tables' amount of data changes from month to month. 1) I want the formula in column K for table 3 to be able to copy values from column B...
  6. F

    lookup value with two criteria with array

    hi can anyone help me in following lookup value with multiple criteria, but i want with array plus, which is faster. array formula or vlookup? date code Rate 25-May-21 613974 0.376 24-Jun-21 613974 0.376 15-Sep-21 613974 0.376 20-Sep-21 613974 0.376 29-Oct-21 613974 0.39 21-Dec-21...
  7. MrDB4Excel

    Lookup Amount Varies For Specific Category

    I have a worksheet that utilizes several functions to get data depending on other information. One “Category” inputs Mobile Phone based on the amount of a given month’s expense. This amount can vary as you can see by the attached Xl2bb. Is there some way whenever the monthly Mobile expense...
  8. I

    Lookup & Sum values between specific date periods

    Hi everyone, Please see below sample data set. The columns are always going to be the same, but the rows will be dynamic each time a report is run. ABCDEFG1Start01-May2End07-May34NoNameDateCategoryTypeDrCr515Name101-MayEntertainment-200690Name201-MaySupplies1500745Name301-MayTravel...
  9. S

    Find Closet Lookup Value

    Hi Hopeing someone can help. I am trying to get a closet value in a table into another cell. Example is Selling Apples. We sell apples in Packs of 2,4,6 We sell the pack sizes of apples in QTY of 10,20,30,40. I am trying bring in the closet value if someone chooses a QTY of 23. Excel would...
  10. 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...
  11. 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 #...
  12. 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...
  13. 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 ? |...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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