vlookup

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

I am building an NBA stat tracking model. As a part of it I am pulling data from each player's Basketball Reference page (each player has their own sheet that is getting data through a query) for the example I am linking to, the player's name is Saddiq Bey (sheet name Bey_Saddiq). Based on that...

Greetings, I am using a VBA Script to retrieve a record set from a closed workbook using the .GetRows method. However, it appears the output is contaminated as I am unable to use a VLookup formula on it. Pasting it into Excel and then recopying it is the workaround that I'm using now, which...

I'm completely stumped on my current formula issue. No matter how I try and manipulate the data the result still ends the same with the dreaded #NA error. Worksheet 1: D E...