vlookup

Hi, I think this should be a simple one but it doesn't seem to be working for me. There is a list of numbers in column A. On the next tab there is a list of the largest 5 numbers from Column A. The largest 5 numbers are in column D. Next to each of them (in column E). I want to write "Exp" if...

Hi, I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...

Hi all, What will be the formula if I key in information in table 1 and it auto appear in the table 2 (meeting planner) above. Thank you. Is it combination of V-Lookup + H-Lookup? I was unable to set the formula. Kindly need expert to teach me. Thanks a lot.

Hi, this is my first post, so take it easy on me. I have a VLookup formula which is standard with the table array on one sheet and the lookup data in another sheet. The formula insists on returning the value from the row above the correct result, I hope this makes sense. So 2 sheets, first sheet...

Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...

Hi All, I'm currently doing scientific work and i can't find a way to find to match 2 table to find the closest date prior to the selection. I was wondering whether you experts can help me. As the data i'm working with is confidential i'm making a dummy table to show what i would need. What...

Hi all, I'm trying to write a formula in order to look for 2 items in a Pivot Table. My table has 2 column: 1- Country (i.e UK, Spain, France etc.) 2- Company name For every new week I have a new Pivot Table and what I'm trying to do is search if Company X (CocaCola for...

I'm attempting to use a Cust Order # to find a monetary value on a different worksheet. I'm only looking for negative values though. This is an accounting audit thing. I'm attempting to find out why a dollar amount on a Customer Order that should have been charged wasn't the final amount that...

Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language). I have 4-digit codes with corresponding names in one sheet and on another I've made it so you type one code on a cell and on the next cell to...

I am referencing an external workbook. Which has a table similar to this one below: (Assume the table starts at cell A1) First Name Last Name Concat Job Search Notes Peter Parker Peter Parker Y Wants a job as a photographer Bruce Wayne Bruce Wayne N Pepper Potts Pepper Potts Y...

I'm looking to copy/paste within the same macro, using 2 different methods, ActiveSheet.Paste and Selection.PasteSpecial. Scenario: Row 1 has a series of cells that I'd like to duplicate to rows 2, 3, 4, etc. However some cells (call it A1) has a formula in it that I'd like to only copy the...

Hi everyone. Has anyone ever used a large table (2 million rows) in power query as a lookup table in a regular vlookup formula in an excel sheet? I'm not talking about a vlookup between 2 tables in power query itself. The large lookup table would be in power query and I want to use a vlookup...

Hi, I am building a VBA macro that will run VLOOKUP on user input with the following functionality: 1. Takes in user typed or pasted data from sheet "Main" 2. Ports the data from sheet "Main" to an array. 3. Array processing: Common invisible characters are removed, data is trimmed, data...

Have tried searching the forums but can't seem to word my question correctly. Here is a basic table:- Date Type Product Qty 01/12/2022 Order Blue Shirt 1 02/12/2022 Order Blue Shirt 1 03/12/2022 Order Blue Shirt 2 04/12/2022 Order Yellow Shirt 1 05/12/2022 Order Blue Shirt 1...

Hey, I have this VBA code that works as a Vlookup with images. However, it only works when I manually enter data in the cell. When pasting values of a whole range of data (or even a single cell value), the Vba code doesn't trigger. Kindly help. I am not much experienced in VBA, and I got this...

I have an employee roster where I am doing a Vlookup using their employee ID from another sheet which has their ID & multiple quiz scores per employee. I'm trying to figure out how to bring over each employee's highest quiz score so that each employee shows the most accurate score. The second...

I'm trying to do a vlookup (or an index/match if those functions are better suited), to find values based on the matching date, as well as 2 headers on a single column, and then I need to sum the returned values. The challenge I'm running into, is that I need to pull the data that matches the...

Hi, I have two columns with values and want to check both cells in a row (A2 and B2) and depending on the value found return the quantity from sheet 2 column 2 Both corresponding cells (A2 and B2) will not have data but there will be data in either of them. Row Column A Column B 2...

I have two tables - Parent table listing asset numbers, and another table with records of services for that asset. I would like to lookup the asset number, search the maximum (last date) it was serviced in the records table, and return the comment that is in another column eg: Thank you :)

Hi, I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15. Order ID Name Poule Number Victories Prop Indicator 845.3333333 James 1 5 0.83 12 497...