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

3
votes
2answers
68 views

In Excel how can I search for #N/A cells?

I'm trying to go to the first instance of a #N/A cell, the result of a VLookup that failed. I know I can conditionally change the value when the result is #N/A, but what I want to do is just locate ...
0
votes
0answers
31 views

Excel - Keeping Original Cell Value with VLookup and Iferror function

I am stuck with a Vlookup formula I'm working with. I need to apply the vlookup formula to a whole column, but here's the catch - I need the formula to not do anything if it returns an error. There ...
0
votes
1answer
32 views

How to optimize fields that has “if” function which return blank value on Excel?

Here is the screenshot, it's only an example since I can't post the original one: I made this worksheet to cross-check the employee present with another sheet that has information whether this ...
1
vote
0answers
22 views

Why VLOOKUP () doesn't work in this example in LibreOffice Calc?

This is a simple working example: A column has these names: اسم عربي واحد in A2 اسم اجنبي اثنان in A3 اسم ثالث ثلاثة in A4 اسم رابع in A5 The second column B2 has these numbers in front of the ...
0
votes
1answer
52 views

VLOOKUP assistance: match column with column on another sheet

I have a fairly simple VLOOKUP Question but I'm comically horrible with Excel. Basically, I have two spreadsheets. I'm wanting to find data from Column B of Sheet 2 on Column W from Sheet 1. If the ...
2
votes
1answer
33 views

Using INDIRECT within VLOOKUP

I am conducting a series av tests of data in different excel workbooks. It order to not have to change all Workbook names in the formulas used I find it suitable to use INDIRECT() and refer to a cell ...
1
vote
0answers
42 views

What's VLOOKUP's true algorithm with range_lookup set to TRUE?

I have not been able to find Microsoft reference that explains the true behavior of VLOOKUP with the range_lookup setting set to 'TRUE' (which means finding an "approximate match"). Their reference ...
0
votes
0answers
41 views

Function To Lookup Values From Pivot Table

I have been trying to use VLOOKUP() to return values from a pivot table but all I ever get is #Ref I tested my theory that the issue is the fact that I am trying to return the data from a pivot table ...
0
votes
0answers
17 views

Two identical values not treated equally in Excel

Was trying to use a simple VLOOKUP on a table with some calculated values (using formulas). It couldn't do exact match, even though the lookup value is equal to the table value. But copying the needed ...
-1
votes
1answer
44 views

vlookup - Is it possible to use vlookup to pull specific info like this?

I am trying to pull the following from each group of Numbers - CHG000509443 05-16-2016 22:48:41 for the Requested CHG000509443 05-17-2016 13:14:35 for the Approved Note 1 - It is always the first ...
0
votes
0answers
8 views

Trying to augment Vlookupall VBA to only return unique values

Am trying to augment the below code to only return unique values. I am currently using this to create a type of picklist where for a given item it returns all of the storage locations that the item ...
3
votes
2answers
228 views

Excel vlookup reference purposely missing shows #N/A - stop it

I have a cell which does a vlookup. But the table to which it refers is always changing and when the specific value is there is shows fine. But when the value isn't there it shows #N/A - how can I ...
0
votes
0answers
20 views

I am looking to reverse lookup missing numbers from a VLOOKUP in Excel

Hi please let me know if this is a duplicate but I did a brief search and did not find anything that wasn't a ton of code that I couldn't relate back to my spreadsheet. I have excel 2003-2007. I ...
6
votes
4answers
486 views

Excel INDEX MATCH Checking Multiple Columns

The problem I'm essentially trying to solve is a VLOOKUP that is checking Columns A:E for a value, and returning the value held in Column F should it be found in any of these. With VLOOKUP not being ...
1
vote
2answers
34 views

Storing numbers as text for VLOOKUP

I am aggregating a large amount of data from several workbooks and need to cross-reference several thousand items, perfect job for VLOOKUP. However, all I get is the lovely #NA error. The issue of ...
0
votes
1answer
39 views

Issue to extract data without Vlookup

I have trouble extracting data from a huge file. Until now I was using Vlookup but of course it only takes the first number it finds. I need to be able to read data in each columns = X,Y,W,Z for the ...
1
vote
1answer
40 views

Excel Vlookup Error for Some of My Text

I have an Excel report with web page titles that I am trying to match corresponding page views to using VLOOKUP. The lookup table is a separate Excel file exported from Google Analytics. When I ...
0
votes
2answers
37 views

How to make excel SUMUP values of multiple rowkeys in a two-dimensional lookup to return sumed up values in a corresponding cell

So I have this challenge with a set of data arrangement and by merging the VLOOKUP and MATCH strings I was able to get my result but there is a little hiccup! Pasted below is the merged string that ...
0
votes
1answer
40 views

Need to extract multiple matches from a list of values

I am trying to extract data from a worksheet using an array formula but it will only return one (the first it finds) value. The formula I am using is: =INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ROW($...
0
votes
0answers
28 views

Extracting a Sublist from Master List

How do I write a formula to find the exact matched of the subsets and extract it from the master? Basically what I have is a master data spreadsheet of 275,000 rows of data. I then have a queried ...
1
vote
1answer
51 views

VLOOKUP for latest non-empty cell

Basically, I've got the following spreadsheet. There are dates along the top. I do a certain amount of past papers each week, and record the highest score I get in a week in cell (paper, week). The ...
0
votes
2answers
72 views

Look up table values in different worksheets to create summary (VLOOKUP, HLOOKUP, INDIRECT)

I'm having problems creating a summary cashflow spreadsheet that looks up a couple of references - a date (which is no problem) and a different spreadsheet name (which is the problem). I have ...
1
vote
1answer
37 views

Look up specific word in a table array and return adjacent cell

I would like to know if there is a way to use the Vlookup function to find specific words in a table array. E.g Table array: Code: R2 Color: Blue Code: R3 Color: Red Code :EC-R2-01-2016, ...
1
vote
2answers
44 views

In Excel, how can I make a row of data in a table that has specific text in one cell automatically appear in a table on a seperate sheet?

I download a report with 8 columns of data into a table each week. The amount of data changes each week by row (one week might have 40 rows, the next might have 100 but no more than 150). The data ...
0
votes
2answers
181 views

If cell contains “Specific Text” return value of cell beside it. Similar to VLOOKUP

I have 2 sheets, one with a list of parts(sku) and all the vehicles that the part will fit on (fitment) separated by "^^" it looks like this: sku | fitment 1 |car1 ^^ car2 ^^ car3 2 |car2 ^^ car3 ...
0
votes
1answer
49 views

Explanation for a VLOOKUP formula used in a Conditional Formatting rule

I have the following VLOOKUP formula for a Conditional Formatting rule: =VLOOKUP(A1,Sheet1!$A$2:$C$17,3,FALSE)<>0 This works fine and does what I want, which is this: If column C (3rd column) ...
0
votes
2answers
45 views

Range mapping in Excel

I have a column of data in Excel with numbers [0..100]. I need a new column, which maps these to a new set of values such that: > 90 : 4 80-90 : 3 70-79 : 2 60-69 : 1 < 60 : 0 I attempted to ...
0
votes
0answers
48 views

How to keep a Value in Excel (constant value)

I have set up a formula, =IF(T74="1/2Dry Stack",0.1,IF(T74="DryMortar Joint",-0.1,0)) Linked to a drop down list on another sheet. How can I keep the value of the formula after making another ...
0
votes
1answer
60 views

Excel 2013 vlookup & sum

I have a data set which shows test results, each person my have several rows of data. My labels are ID - Test Date - Test Result - Interval Between Tests I want to sum the interval between tests ...
0
votes
0answers
26 views

How do I IF & VLookup?

How do I ask IF the cell is found in another table pick the cell information next to it in the other table? I know this is an IF and Vlookup formula, but I'm not getting the If statement correct ...
0
votes
1answer
186 views

How to populate information from one sheet to another in Excel Workbook?

My current task is to create a formula where my information from one sheet will auto populate in another sheet when the product description is copied. To be specific, we need to have the items ...
0
votes
1answer
26 views

Using a Date to refer to a page to VLOOKUP into

I currently have data that has a date and item number and I'm looking to pull the price from a different sheet. =Vlookup(#,Jan1!(Range),2,0) Gives me my price of Jan 1 =Vlookup(#,Jan3!(Range),2,0) ...
0
votes
0answers
45 views

Vlookup stopped working when I changed the lookup cell reference

I have a case where I need to change the lookup value reference in a Vlookup but I can't get the new formula to work. Old Formula: =IF(IFERROR(VLOOKUP($CQ2;'TrackerStatus TRO'!$A$2:$BG$65536;2;...
0
votes
0answers
56 views

Conditional formatting to highlight differences between 2 pivot tables in Excel

I have an Excel issue I hope somebody may be able to help me with please? I have 2 pivot tables that both contain the following fields: 'Provider ID' in the Rows area, 'Month' in the Columns area ...
0
votes
1answer
89 views

Vlookup in Excel returns #VALUE

I am using two worksheets in Excel but am having problems with using VLOOKUP. Sheet 1:- ID CATEGORY_ID Sheet 2:- CATEGORY_ID CATEGORY_NAME I essentially want to add the CATEGORY_NAME in ...
2
votes
1answer
70 views

VLOOKUP and IF in multiple excel sheets

I have two excel sheets, as below, in a workbook Sheet 1 & 2: Below is the relation of fields between the two sheets EID is same as EmID DepID is same as DependentID DepDOB is same as ...
0
votes
1answer
58 views

finding two adjacent cells using vlookup()

In preparing my data for an interpolation within an interval, I am using the MS Excel vlookup() function to find a pair of values that will define the interval for my interpolation. The default ...
0
votes
1answer
44 views

Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another

I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...
0
votes
1answer
37 views

VLookup function solution requested

I have an excel spreadsheet which has got all the data. Column A has the staff initials such as AA, SH, SG.This goes down the column. All other columns there are various data such as fees, amount ...
0
votes
1answer
41 views

how to concatenate the output of vlookups in one step

I'm trying to run two vlookup operations and concatenate the results in one formula as such: =CONCATENATE( VLOOKUP($A$6,'TRP'!$A$7:$D$655,2,FALSE), "/", VLOOKUP($A$6,'HCP'!A5:B655,2,FALSE) ) The ...
0
votes
1answer
81 views

Return value with if and vlookup

I'm trying to create a formula that can help me maintain a list. I have drawing numbers and revisions on one sheet. I need to like bring that to the main sheet for each drawing number that is on the ...
0
votes
1answer
72 views

Reverse vlookup

I have a list of descriptions and I want to add a code column as shown below. The descriptions in the list are neither unique nor sorted. I have an index table with substrings and the codes in ...
0
votes
1answer
337 views

Build a lookup query in Excel using named ranges stored in a cell

I have a spreadsheet which has a lot of named ranges, each of which is a table. I want to be able to run a lookup that will retrieve a value from any of the tables. I want to be able to store the name ...
0
votes
1answer
122 views

VLOOKUP cells that contain a certain text in Excel

The challenge is as follows: I have a column with names extracted from a source. The names come in different ways each time it is extracted. For me to be able to use it, I need the names in a specific ...
2
votes
2answers
270 views

Excel - return multiple values for each of a list of values

I've been trying to solve this for a good few hours now, but with no result... My setup: I've got excel sheets of cosmetics product recipes. Each recipe contains dozens of ingredients, each given ...
2
votes
1answer
21 views

Making one list from other data using a lookup

I have 2 columns of data in an excel sheet - Column A:A is an id number, and column B:B is a binary 1/0 response. I have > 1, 000 rows of data. Example 0001 1 0002 0 0003 1 0004 ...
0
votes
0answers
39 views

Find and Replace in .txt file by extracting data from spreadsheet

I need to replace instances like Manhole Name="1" with Manhole Name="SW3/001" for instance by extracting the data from spreadsheet. Would that be possible using regex, or in any possible way ? ...
1
vote
1answer
276 views

Excel Sort and Lookup Values Formula

I am trying to create some sort formulas on excel. An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...
0
votes
2answers
906 views

How to lookup a value and return multiple unique values to a single cell - comma separated

I am attempting to lookup a unique identifier (Product Number) which is held in several different stock locations. For example: __A__ __B__ __C__ 1 Item # Warehouse ...
0
votes
1answer
46 views

VLOOKUP returning N/A because references contain “.” and “ ” in one table, not in other

OK I am trying to vlookup a table but the problem is the references on one table are slightly different to the references on the other table. I can get the VLOOKUP function working, but it is ...