vlookup

  1. D

    Find a cell in a table, and return the value above

    So I'm trying to return a cell value from a table, relating to a text based cell as the searching tool. It's actually part of a larger formula, but the rest is straight forward. I am trying to return a result where if the day of the week changes in A2, it changes what cell I use in a formula in...
  2. I

    Vlookup a column with duplicate value, return the number from the last row

    Hi all, I've got a table with 4 columns(B~D), Item, Store, and Time. In Column E, I want to write a function that looks up the value from "Item" and "Store", then returns the value of "Time" of the last row where both "Item" and "Store" values are matched. So for example, E3~E9 will have the...
  3. F

    Formula to insert a picture based on various cell values, w/out VBA, Macros, etc.

    Likely a tough one here. Simplifying a complex worksheet here. But basically: A1 = Value A2 = Value A3 = Value A4 = Value A5 = Picture based on A1:A4 values. Limitations: Pictures have to be referenced from within the excel Workbook. Not external to a referenced folder or website. I can...
  4. K

    Return a user specified number of cell values to a comma list randomly

    I have variable lists that will have 200–1000 values in them. ex: 1 Reliable 2 Practical 3 Responsible 4 Organized 5 Detail-oriented 6 Logical 7 Hardworking 8 Dedicated 9 Honest 10 Loyal etc... The user will be able to put a number in a cell and a different cell will...
  5. N

    Find Latest comment for ID using vlookup/MAX?

    I would like use a vlookup or equivalent to pull the latest comment for a specific ID. I can’t figure it out. I’m thinking maybe MAX but I’m not using it correctly. I think i need the vlookup because I am filling in cells in another table with the latest comment for its ID. In this example I...
  6. I

    Evenly auto assign based on availability and language

    I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.
  7. R

    vlookup, INDEX, or SUMPRODUCT???

    This hopefully comes through okay. I am looking to automate the information going into columns G and H. I highlighted the date ranges to make this a bit clearer. In the real world I will have "Source 2" with samples every 10 minutes. "Source 1" is just whenever a fault occurs. The goal is...
  8. R

    Finding Period within date range

    Hi, I require a formula in C18 (Red) That uses the date in C18 (Green), searches it within the date ranges of Columns D and E, and produces the result of Column G depending on which Row that date falls on. Thanks in advance.
  9. K

    Sumproduct with 3 tables?

    Dear users, I am trying to do the following but have been unsuccessful therefore I seek your help; I have vendors who buy TVs from certain Towns. The top left table displays the quantities of TVs bought by each vendor who has a record of purchase while the bottom left table displays the...
  10. M

    Complex Lookup issue

    Hi Team, I have two excel files attaached screenshots I am trying to do a lookup { bring values of 3rd column {approved} from 1st sheet to 2nd sheet} but for each unique id which is my first column in both sheets. I have duplicate values in first column and in second column i have string like...
  11. M

    create table from data on second sheet

    Please tell me to go away if you like. I have a table full of names (starting at B3 to H3), column A has which sites to work at. I need to 'transfer' the data in columns D to H from this table to another sheet depending on the site in column A I think this is a VLookup or a filter formula...
  12. M

    Auto-populate data from multiple sheets into one master sheet- Help

    I created 11 different tabs to be filled out. Is there a way to have the data in each of those sheets auto-populate into one master sheet? I need to show the totals of each product selected. I only included the Master Sheet and 2 tabs below. Thank you for your help. Master Sheet...
  13. E

    VLookup for the second instance

    I'm trying to do a formula where I'm looking up the rate in a particular column in a table based on an ID number (first column). Each ID number shows up twice in teh table (once with $ amounts and then second with a rate). How do I do a vlookup formula to show me what is in column 3 the second...
  14. S

    Lookup on Merged Cells and Multiple Columns Below

    Hey everyone, I have struggling with this for days now...and my team is depending on me to figure this out soon. I need help with doing some sort of lookup on data that is in different columns below a merged header cell. I need a specific cell to be chosen based on the name that I input. For...
  15. T

    V-Lookup in a cell with more than one value present

    I am in need of a formula which will search for a specific value in a column of cells that may contain more than one value in each cell. e.g. A B C D E F 1 ROLE RESULT ROLE RESULT 2 897 BONUS 563, 897 BONUS 3 167 #N/A 4 897 BONUS 5 637, 598, 897 BONUS 6...
  16. R

    VLOOKUP formula using the TEXT function as the "lookup value"

    I have a lookup table where the lookup column is a combination of letters & numbers. I created an VLOOKUP formula that looked at the first column as all "text" values. A portion of the lookup table was as follows: AA AB 2 97013T 122320 3 #97015T 122266 4...
  17. K

    Create list of cells from one column that matches one criteria and separate based on another cell criteria

    Can anyone help me make the following happen? I want to take the data from sheet 1 and have the results in sheet 2. I have a table that shows the Project name, status, allocation, start and end date, and the personal (Attached image) I would like to have sheet 2 auto-populate a consolidated...
  18. D

    vlookup exact AND partial match

    I cannot seem to write a vlookup formula that provides what I need. I am looking to search Products in A8-11 and return price in B8-11. I need to match A2 AND B2 in this search. As you can see, partial results should show for A8 and return the corresponding price in cell B8. Can you help...
  19. skyh3ck

    1st match column header, 2nd lookup a value in same column, 3rd return corresponding value from the very first column ?? need help

    Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...
  20. N

    Auto Allocate Account from the Master Sheet

    Hi, I want to allocate the financial accounts based on the narration string in the Bank statement, I have created one sample excel workbook with two sheets. There is a "Statement" sheet, which is the snapshot of Bank statement, I want macro or formula to read "Narration" column and pick-up the...

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