vlookup

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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