VLookup is a Microsoft Excel function that searches for a value in the left-most column of a table array (a range), and returns a value in the same row based on the column number from which the user wishes to retrieve the value.

learn more… | top users | synonyms

0
votes
3answers
26 views

Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...
3
votes
1answer
38 views

Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column? Let's say I ...
0
votes
1answer
18 views

Vlookup column a and find highest version number in column b

I have a list of part numbers in column A: in column B is a version number of the part number. The part number can be repeated and the version number is unique. I want to lookup the part number in ...
0
votes
1answer
28 views

Excel Index Match for multiple conditions evaluates correctly with F9 but not in cell

I have an index match formula that evaluates correctly if I use F9, however when I actually press enter it returns #N/A. The formula is designed to perform a vlookup on two conditions: ...
0
votes
1answer
31 views

Using vlookup / index match for this circumstances

I have some data which are grouped like this: 1st group of data(gender): Male, Female 2nd group of data(age): 12,13,14,15 3rd group (score + grade): For each gender and their corresponding age, ...
0
votes
1answer
42 views

How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns: ID | Name | Semester | SemesterAvg | Overall Avg | Period | 1 | John | 1 | 2.5 | 2.5 | 20132 | 1 | John | 2 | ...
0
votes
2answers
64 views

Needs VBA solution - Clear contents of 4 cells to left of cell with N/A Error

I have a table of data in which column L has a vlookup formula. In the rows where column L (i.e., the vlookup returns "#N/A"), I would like to clear the contents of the eight cells to the left ...
0
votes
2answers
79 views

IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...
0
votes
1answer
37 views

Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc) I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...
0
votes
1answer
91 views

How to lookup a value and return multiple unique values (remove duplicates) to a single cell - comma separated

I am trying to take a value (unique id) from column AC, do a lookup in column (B) and return (meaning concatenate) the multiple unique values from an adjacent column (C) to a single cell in column AD. ...
-1
votes
1answer
43 views

I need a cell to automatically fill when data is entered into a neighboring cell

I would like cells E5-E39 to automatically fill with data in cell P1 when data is entered into cells B5-B39. So when something is entered in cells B5-B39, E5-E39 are auto filled with the info in P1. ...
1
vote
2answers
157 views

I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula. Thanks.
0
votes
1answer
26 views

I need the number in a cell to countdown when data is entered into other cells.

I'm making a sheet to keep track of the number of software licenses. In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total ...
0
votes
1answer
38 views

Excel 2010 - VLookup -

I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible. Here is the example: Id Owner Name A1 Owner 1 ...
0
votes
1answer
46 views

Can I use VLOOKUP to return a table name that is then used in an INDEX formula?

I have an INDEX formula like this: =INDEX(Data3,MATCH(G4,Sheet2!$A$14:$A$17,0),VLOOKUP(F4,Threshold,2,TRUE)) However, I want to apply this to data where the table I want the INDEX formula to ...
1
vote
1answer
33 views

How to CONCATENATE a VLOOKUP and have the lookup take place without an CR after a copy and paste value

A B C =VLOOKUP(C1,B6:C8,2) =VLOOKUP(C1,B6:C8,2) =VLOOKUP(C1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(A1,B6:C8,2) ...
0
votes
1answer
43 views

How do i do a “tweaked” VLOOKUP?

So here is the problem: I have 3 lists (adjacent columns) in a spreadsheet. The 1st list contains the values I am searching for The 2nd list contains the first half of table array which I am ...
0
votes
1answer
55 views

Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets Sheet 1 contains 2 columns. Column A has a range of unique alphanumeric identifiers. Column B has a range of non-unique numbers. A B ...
1
vote
2answers
631 views

VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table

I'm going bonkers trying to figure this out. I thought I hit the jackpot when I learned about INDEX-MATCH and the additional flexibility over VLOOKUP, but that flexibility doesn't seem to help when ...
0
votes
1answer
54 views

How to find a specific row in Excell

I am looking for some formula in Excel like give me the number of the row which its first column is 5 and its second is 3 I have searched the web but I have found lookup, search, find and ... which ...
0
votes
1answer
48 views

How do I fix this VLOOKUP that returns last row value for date lookup?

I am running into what seems to be a very basic issue with Excel's VLOOKUP function (Mac Excel 2011). I've downloaded historical stock prices from Google Finance for Microsoft and then copied that ...
0
votes
3answers
135 views

Enhanced Vlookup Excel Formula

I am looking for an excel formula that I can use to automatically fill E2 in the screenshot below. The intention is to find Marc's age from column B, ie E2 should be 20. Any ideas please? I have tried ...
0
votes
1answer
63 views

Can't get VLOOKUP working with roster spreadsheet

I have an Excel spreadsheet set up as a roster. The way the roster is setup is for the ease of the person creating the rotation. This roster is not easy to read for the staff. Mon ...
1
vote
4answers
446 views

Lookup returning #n/a - would like cell to be blank

I am using this formula to look across multiple sheets and return the value: ...
1
vote
2answers
77 views

Searching a value in a column in Excel

I have values in A1:A1000 and I have another column of values from B1:B500. I want to check whether A1 is present in B1:B500; if it does I should get as PAID if it doesn't I should get NOT PAID. ...
0
votes
3answers
3k views

VLOOKUP using CONCATENATE values

I have workbook1 with 3 values (columns) concatenated to 1 cell as =TRIM(CONCATENATE("ABC","-",$B174,"-",$A174,"-",$E174)). Workbook2 has 1 cell that contains the concatenated value from workbook1. ...
0
votes
0answers
447 views

Lookup across multiple sheets and return a value to the left (Left-lookup)

I can use the following array formula to lookup a value across multiple sheets (I'm using the defined name 'ProductLines' for my sheets) and return any value in the same row in columns to the right of ...
0
votes
1answer
77 views

merge two exel sheets and update duplicate value

I have two exel sheets and I need to merge this sheets but in sheets 1 i Have 800 records in sheet 2 i have 20 records and some of value from sheets 2 are duplicated in sheet 1. I wan to update ...
0
votes
1answer
221 views

Compare multiple columns with another sheet and if matched return true

I have a sheet named Test with columns [Category],[SubCategory],[Name], [Is in share?] that need to be compared(except for the column [Is in share?]) with the sheet named Share. Share also has ...
0
votes
0answers
65 views

Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following: Sheet1 Fruit______ Orange_Apple_Banana ...
1
vote
2answers
736 views

Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value

I have rows of possible duplicate employee ID #'s, with another column of different values for the same person. I need a single column of unique ID's with the certifications transposed in the same ...
0
votes
1answer
2k views

Excel 2010 vlookup formula - Using variable table array as input

I been trying to find out if its possible to automatically expand the table_array on this VLOOKUP formula: =VLOOKUP(B2,Sheet2!$F$4:$G$965,2,FALSE) I'm calling the values from Sheet2 to add into a ...
0
votes
1answer
137 views

Copying VLOOKUP formula in multiple sheets, where sheet number automatically changes

I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered ...
0
votes
3answers
110 views

Find entity in a list of entities and give back another cell value based on which category it belongs to in excel

I want to find a nice way to get a specific value based on a category and another characteristic. I'll try to to exemplify it below; Problems: 1) I want to check what category a certain entity ...
1
vote
1answer
50 views

VLOOKUP not interpolating all cells?

My VLOOKUP formula is not interpolating all cells AD AE AF 11-6-2014 15:20 90,4 #N/A 11-6-2014 15:21 89,1 #N/A 11-6-2014 15:22 90,4 Good 11-6-2014 15:23 89,1 Good AF column is my ...
0
votes
0answers
88 views

Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...
0
votes
1answer
71 views

EXCEL MAC: VLOOKUP copying the date instead of the data

First of all, am sorry if this was already posted by someone else, I tried searching for hours now, but did not find something similar to what I have here. I am very newb on excel. My problem is, I ...
1
vote
2answers
3k views

How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...
0
votes
1answer
172 views

Excel: How to find a range, from a list of ranges, that a value is in?

I hope someone can answer my question! I have lots of values and need to know which ones lie within a list of ranges and if so which range do they lie in. For example: worksheet 1 contains my ...
0
votes
0answers
58 views

Vlookup from formula in Excel 2010

I would like to use a vlookup, where the value being looked up is the result of a formula, however my formula below results in an error. It works if I type in the result of the formula, but not for ...
0
votes
1answer
285 views

Excel SUM From Different Sheets IF Date Found

I have a workbook with separate sheets for each product (about 20 sheets, adding more on a regular basis). Each product is only available for a certain time frame, and has daily sales data recorded on ...
1
vote
2answers
20k views

Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...
0
votes
1answer
106 views

In Excel selecting an item from row when cell matches the first item in that row

I have a LIST of 5 optional sizes. There are several numbered mating parts that coincide with each of the sizes forming a pair. Any 1 of the mating parts can go with a chosen size, but only 1. Some ...
0
votes
1answer
67 views

Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula. First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...
1
vote
0answers
38 views

Trouble adding values from different ranges in excel

I have a fairly unique problem I am having trouble with. Essentially, I need to fix column U on Sheet 1. Ignore stuff out of the tables, as most of that is stuff I either will hide but reference, or ...
-1
votes
1answer
658 views

With VLOOKUP, if N/A, keep original value

I'm using Vlookup to find a value, but when it doesn't work, it returns N/A. How do I keep the previous value instead of having NA. I have found the answer HERE How do I implement this? Do I just ...
0
votes
1answer
303 views

=VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side. I want the B2 cell to display the salary ...
1
vote
1answer
319 views

In Excel 2011 on Mac, how to return a non-blank matching value with vlookup?

I have a list of domain names and their registrars on one sheet, and the same list of domains and other data (but not registrars) on another sheet. I need to get the registrar name from sheet A, to ...
0
votes
2answers
343 views

MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified. So let's ...
0
votes
3answers
120 views

How to use =VLOOKUP under these circumstances?

So I know how to use =VLOOKUP when you are searching for a single value within a cell, but I'm not sure how to do it when I have a range, ex. say the cells value is 1-5, the next is 5-10. This is ...