vlookup + index + match

In one worksheet say "sheet-1", I have column D as a derived value after concatenating values from A,B and C column. After concatenating in column D an alphanumeric value is displayed in column D like "PRIV-098876-BOOK-909898" There is a separate sheet in the same worksheet say "sheet-2" where...

I have a large data set with a 'description' column that is not always uniform, for example it could read "bla bla bla depreciation" or "depreciation bla bla bla" and both should be tagged as 'Depreciation' in a separate tagging column. Is there a way/formula which I could create a mapping...

Hi quite new to this, My question is how to compare 2 cells in sheet 1 against 2 cells in sheet 2 and if the cells in sheet 1 match those in sheet 2 then return an offset of from the match cells in sheet 2. Index, Match or vLookUp??? Is there another database function? Looking forward to your...

Hello, I have figured out how to compare and search two columns to return a corresponding value, but there are multiple values that may match, and I am unable to collect the multiple values. The headings I am searching are below: Full Name (this is the column I am searching - Column A)...

Hello, I use VLOOKUPs quite regularly but it seems it doesn't like to reference a range of numbers just a single number. In the example below, I want to return the four-letter codes in column A where the corresponding percentages in column B range between 6-7% with the codes going into...

I have been playing around for a while now but no matter how hard I try I just can't get my vba coding to work for what I'm trying to do. I have had some limited success with match and index witch seemed to give me almost what I needed. Ok so this is what I'm trying to do. I have a item number...

Data: A : B: Wilbraham John Wagner (first row, row 1) Wilbraham Casey Smith Wilbraham Chris Kavanagh Wilbraham Josh Gorman Springfield Tom White Springfield Elizabeth Crowl I want to be able to lookup wilbraham and receive the the four names that correlate...

I have two tabs and want to return a value in the first tab. First tab - column A (Lname),B (Fname) and C (visit date) need to match to the second tab for the value. On the second tab - column A (Lname, B (Fname) and F (Visit date) where K (charge amt) is the value i need returned to the...

Hello, I am knew to the thread and requesting any possible assistance on a formula. I have a workbook that has 15 worksheets. The first worksheet contains information contracts with that I have to manually input on the applicable worksheets-based on their project. I would like to use a formula...

I'm trying to lookup a person's name and return an ID number (Spreadsheet 1) from another spreadsheet that has the name and ID number (Spreadsheet 2). However, the names in Spreadsheet 1 may only contain either partial text, or contain more text, slightly different text, than what is in the name...

I have a data set which contains test results for students, and I need to be able to compile them onto separate sheets. The original sheet looks something like this: Name...............Subject.......Date..........Score Smith, John.......Reading.....4/7/15.........5.5 Smith...

Hi All, I have a spread sheet where Column B contains a number of repeated numbers. I want to know if it is possible to look at these and return the highest and lowest value from Column A. part of the table is shown below. I basically need it to either delete all List ID CN3620969 apart from...

Hi, I want to do a standard vlookup on a value in a column in spreadsheet 1 and populate a new column cell in that spreadsheet with a cell from spreadsheet 2. But the value im looking up may be repeated a number of times in spreadsheet 2 over different rows. Each time it is repeated, i would...

Hello! I have 2 spreadsheets (A=Response Database & B=Mail List Database) and I am trying to pull information from B to A. I need to enter information in column G - in spreadsheet A from column G from spreadsheet B based off of the information in column C - spreadsheet A. My formula is...