lookup

  1. brendalpzm

    Calculate Age with vlookup to fill a text box

    I have these activeX controls fields: EmpNoBox = Employee Number (TextBox) AgeBox = Final result with age (TextBox) **These 2 are located in the "Registro" worksheet In a different worksheet called "Base_Externos" I have a data base with the employees information, employee number is located in...
  2. B

    Dropdown List Help

    Hi, I really hope someone can help me make this drop down list. I have a cell that a user will type in a acronym. Cell B1 I have a range of acronyms in a separate tab (about 700 of them). I would like the user to presented with a drop down list of cells within the range that contain those...
  3. K

    Fill by matching and adding rows for multiple matches

    Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...
  4. T

    Find a value, display, whilst ignoring duplicates

    Hi Guys - looking for an expert to help with this one. Having trouble in finding/showing values (E2 | F2 | G2) when there are duplicates in a range (A2:B8). Essentially: Cell E2 - Lookup D2 amongst Column A, display adjacent value (display B3 - 1111A) Cell F2 - Lookup D2 amongst Column A...
  5. T

    Look up reference item, find all occurrences of certain text relating to that item, and count adjacent cell

    I don't even know if this is possible, it was hard enough figuring out the title for this post. So to give context to my problem, I'm given a sheet from our payroll team of all the leave taken in the previous month for each of our locations within the business, and I need to add up the total...
  6. S

    Vlookup with Search function

    Hi All I have two tables i am trying to look up one for the other. Table A is a list of licenses by Country with the Product names for each. Table B is a list of the Product sales. The same Product code can be sold in different countries are in same cell separated by a semi colon. Does...
  7. S

    VBA to Highlight Rows that Contain Any Keywords in Lookup Table

    Hi all, I've scoured the internet for a solution and have tried coming up with a solution myself, but I'm just not proficient enough with VBA to be able to do it (and all of the solutions that I could find online involved a popup input box to manually enter keywords each time). I'm trying to...
  8. A

    Lookup give a wrong value, how could I fix it?

    Hi guys, trying to fix this issue. The formulas were written by somebody else. This is my formula: =IFERROR(LOOKUP('QCP Review Data'!H10,'Group list'!A:A,'Group list'!B:B),"") Data in Group list A:A are different test codes, and B:B are several groups. So theoretically, the formula should be...
  9. E

    how do I look up article numbers with spaces and sometimes one or more leading zeroes

    Hello! I need to look up an article number in a table and return a text associated with this number. A pretty easy task it seems, BUT I can't get it right! The workbook has two sheets I recieve article numbers from one program with some content I past this content in "Materiallista". In...
  10. G

    What is fastest formula and input setting between INDEX-MATCH, INDEX-XMATCH, and XLOOKUP?

    Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...
  11. A

    Data in columns should show for 60 days at a time

    I have a spreadsheet that populates the data grid based on certain other calculations (which is all working fine) and I want to add a lookup function so that the data is only shown if the first entry in that column was less than 60 days ago. The challenge is that the spreadsheet does not have...
  12. R

    Store matching values in an array with VBA

    Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks
  13. B

    return last populated cell based on lookup conditions

    Hi All, I need some help with a formula which is not working the way I want it too. I have columns with dates and rows with values, see below: my current formula in column M is: =IFNA(LOOKUP(2,1/((Q10:DA10<>"")*(Q10:DA10<>"Y")),Q10:DA10),"") What it currently does is pick up the last cell...
  14. A

    Power Query - filter & lookup values based on another table

    Hi all, I have a table that I would like to add to a Power Query and then: filter one of the columns based on values that appear in a column in a separate table in a different worksheet add an additional column that gets populated using a lookup against the separate table I've provided some...
  15. T

    Power Query: Apply a Transformation to a Dynamic Column Range

    Hello all, I've written a transformation to look up a column header in a table and return the number of hours corresponding to that value. The original value in the cell is then divided by this number. The amount of header columns and their names can vary depending on the workbook so it doesn't...
  16. F

    "Match & Index" or "LookUp" to look up values

    Hi all, Hope you guys are well. Please check the attached pic. I need to find out the value of "Stock Code" from "Table 1" to "Table 2". Is there any ways I can do it? Thanks in advance :)
  17. O

    Find Trimmed Mean of all the values of an item

    Hi. Stumped on this for a while. I would like to find all the values of an item in a range like a sort of index-match, then find the trimmed mean of those values, and repeat this process for each of the other items in the range. Attached is a sample sheet showing what i would like. Would be...
  18. E

    Match a County to a City found in an Address

    Hey, I am looking for some guidance on how I might achieve the following: I have a column (column H) of full addresses, for example: 1234 SW 80th Pl, Miami, FL 33331 On another sheet, I have a list of COUNTIES in column A, and CITY in column B. COUNTY CITY Palm Beach Acacia Villas...
  19. C

    Indirect lookup - formula solution needed

    I am using Excel 2016. I would like to do a lookup function that also involved the indirect function. I have multiple worksheets which belong to a coach and are titled accordingly - 'Peter' 'Sally' 'Chris' etc. On my active worksheet I have a table that looks like below: (assume the below...
  20. TheMacroNoob

    Search Multiple Sheets for Conditional Values

    Hello Excel Experts, I have a potentially novel request: I have 22 sheets with the exact same formatting/cell positions. I would like to grab values from all sheets that meet criteria. If Column C contains "Yes" on any sheet, I would like the sheet name (contained in cell A1), the Building...

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