vlook up

hi all good people i have a spreadsheet with over 27000 rows of data and 11000+rows of reference data My reference data all unique, however some of the cells have a string that is similar for example c/dog/001/01, c/dog/001/02, c/dog/001/03, c/dog/002/01, c/cat/001/01, c/cat/001/02...

Hello everyone! I am in the process of making a dropdown-based table to fetch data. I have gone through the motions to create the dropdown via data validation, and that works fine, however I am in the process of trying to get the data I need and I will get N/A in the cell. The table I am...

Hi, I’m in the process of developing a reporting template and have become stuck. I’m working with a fixed report format and so have to produce a summary from separate tabs. I need to calculate the total spend for a specific quarter or year, depending on the value chooses from a drop down...

So I have database using lot's of VLOOKUP, but they all refer to the same array ,where new column needs to be inserted in the middle of array. The array in formula moves, but columns remain the same. Hence it pulls data from the wrong place now. Is there a way to basically add 1 to every col in...

Hello everyone, I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count...

Hello, I'm trying to pull what a service rate would be based on a position and a specific rate card. For instance I have a list of titles and rates, and a list of titles and rates under different rate cards. I am looking to pull back the rate for a title under a specific rate card. Sheet 1...

Hi Guys, I'm trying to work on a macro but I'm just recording it and here's what I got: Sub Macro1() ActiveCell.FormulaR1C1 = "=VLOOKUP(C1,PvA!C2:C17,16,0)" Range("AB5").Select Selection.Copy Application.Goto Reference:="R10000C28" Range(Selection...

Hi Guys, Just wanted to ask you have any other way of doing vlook ups in a fastest way. Example: Reference Tab <tbody> ID Name Subject Score Note 001 Ben Math 90 N 002 Ana Science 97 003 Sean Science 85 004 Millie Math 87 </tbody> LookUp File <tbody> ID Name Subject Score Note...

Hi I have not used either of the formulas before but would like to learn the basics. in my 2 worksheets, I have information about the same staff but each worksheet refers to different budget. I started entering on worksheet 1 if the staff is current or ex (column exited - if staff left there...

Hello Team MrExcel, It's excited to post a query here, I hope would get a solution here. I have a question about vlookup, How to pullout multiple values on a cell? Expecting data pull out as below by using Vlookup, which will help me a lot. Need your help! Could you pls help...

Hi, I am writting a vlookup: =VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE) This formula currently returns the bottom value in column 29. however i want this formula to return the bottom value that is not equal to zero. so i need to try get a <>0 in somewhere but I cannot figure it...

Hi Guys, Can you possibly help me out on the macro I'm trying to sort out? Basically, I have this excel file named "MasterList" with two tabs sheets namely: Master & Reference. The master contains a list of data while reference sheet has list of countries and its equivalent country group...

Hi Guys I have the below table which is used as a data set to populate a second table (All on the same work sheet) <tbody> Product Name 500g 100g 10g Product 1 $50 $20 $5 Product 2 $69 $30 $7 </tbody> My second table has a 2 dropdown list 1. The first which is populated with...

Hi Everyone I am looking for the best way to arrive at the overall percentage increase of the salary figure [B2:B5] applicable to people based on their employment start and end date (let's assume all still employed). If a person was employed at a given 6 April [A8:A12] an increase applied...

Hi all, I have a set of data in column D which is formulated which pulls the value from different tab with Vlookup function. I need a nested formulae where it can sum up the value automatically at the end of the row as shown in red color. please note the line items are not fixed so, formulae is...

Hi there, I require assistance in being able to determine the differences between two excel spreadsheets. I have a bunch of data in Sheet 1 and these data has been altered and saved in Sheet 2. Now, I would like to be able to highlight in Sheet 2 which cells have been altered. The main point...

Hi, I have a UserForm that takes data from a table on "Raw Data" tab and inserts it into a different table on "All" tab. Now things are getting complicated and I would appreciate some help/advice: With Vlookup I can have 1 criteria, but I need to return values based on 2 criteria. <tbody>...

I have thousands of rows like that - These are the keywords <tbody> A1 NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY BASKETBALL <tbody> A2 New IXO Collated Screw Gun (Cordless) home use screw gun cordless for everyone <tbody> A3 Set of 3 stainless steel soup pasta salad bowl...

Hi, I new to this site and this is my first post, generally i poor in excel so please guide me on this Thanks in Advance. Red Highlighted valve are outcome of the formula This formula need to read two column (WS and R/F) at the right side, Both Columns are manually entered, outcome is total...

Hi guys, I was hopeful someone could help me out with a Lookup function (IndexMatch, Vlookup, or Hlookup) for the following data. The objective is to look up what is in column A (Weeks) and find its match in the array F2-I8, and bring the value E1-I1 into column C. <tbody> A B C D E F...