Questions tagged [vlookup]

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.

179 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
1 answer
2k views

Excel: Why is VLOOKUP returning inconsistent and unexpected results?

I'm automating an Excel column to assign account values based on the vendor paid. For instance, if AT&T gets paid, the account value is Utilities:Telephone, and when the post office is paid, the ...
dwwilson66's user avatar
  • 1,749
2 votes
1 answer
2k views

How to create dynamic sheet references with cell text in Excel

I am working with a large workbook and I want to drag formulas across to reference the title of their column with the corresponding sheet of the same name. In this example: =VLOOKUP($B3,'04.22 NE'!$B$...
Tarryn's user avatar
  • 21
2 votes
2 answers
281 views

Excel VLOOKUP function giving the incorrect value. Can somebody identify mistake?

I have been using the VLOOKUP function a lot in Microsoft Excel but these last two days have been rough. I have been trying to "match" the state population with the state name. I was able to use the ...
piza25's user avatar
  • 21
2 votes
1 answer
193 views

VLOOKUP() to a Table on a different worksheet returning an #N/A error

I have 2 tables, daily entry and summary My formula in BQ20 of the summary table is currently: =IF(VLOOKUP(BQ5,Table11[DATE],1,FALSE),VLOOKUP('SUMMARY (NEW)'!B20,'DAILY ENTRY'!A:H,8,FALSE),"") ...
Nao's user avatar
  • 21
2 votes
1 answer
108 views

Creating a repeating vlookup table for raw materials

I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with the following properties such as ITEMS MATERIALS ...
Ikeda Kouji's user avatar
2 votes
1 answer
901 views

Excel VLOOKUP using results from a formula as the lookup value

I have a cell that I must remove the first 2 characters "RO" for each value in a column on a sheet called RAW DATA and put into a cell on a sheet called ROSS DATA. Some of the values in that cell have ...
Rick Deemer's user avatar
2 votes
2 answers
291 views

Excel Formula CONTAINS

I need a formula that will look for a specific text in a cell that is also referenced on another sheet and input the value next to it. Kind of like a vlookup but with an if statement. "if text ...
Tiffany's user avatar
  • 21
1 vote
0 answers
60 views

excel storing values that are being inputted daily

I have the following input in my excel, which somebody fills in manually every day. The date columns have the following formulas: =WORKDAY(TODAY(),-1) and =WORKDAY(TODAY(),-2) At the beginning of ...
Tobias's user avatar
  • 11
1 vote
4 answers
231 views

Excel VLOOKUP multiple columns

I want to pull through 6 columns of information from 1 sheet to another sheet on excel when I type a customer name. I've tried multiple different array and vlookup formulas and nothing is working for ...
Samantha Haxton's user avatar
1 vote
1 answer
36 views

Vlookup search Bug

When I use VLookup to auto fill rows from a chart, it works for every search value except searches where the lookup value is CPT-X. In this scenario original formula: If I change the lookup value to &...
Spencer's user avatar
  • 11
1 vote
0 answers
567 views

how to perform VLOOKUP on two separate excel files

I have two separate excel files. I want to copy the value of column code from file 1 and paste it to a new column (lets say code) in file 2 where the value of column ID of file 1 is equal to that of ...
Shahriar.M's user avatar
1 vote
0 answers
785 views

VBA vlookup for multiple columns

I am trying to compare two tables of data on the same sheets and display matches in a 3rd table. I can get the first column in the 3rd table to return matches however the other matches don't display ...
Preeber82's user avatar
1 vote
0 answers
15 views

Variable within worksheet name

I have a VLOOKUP that looks like this. =VLOOKUP("MISC",'[lastname^J Firstname.xlsx]Lastname, Firstname 2021'!$A$15:$M$21,2,FALSE) How can I make the "2021" in the sheetname a ...
user1280426's user avatar
1 vote
1 answer
357 views

Excel - Concatenating cells returned through looking up against duplicate values

I have a unique problem that I have been unable to solve and hoping to get insights from the experts here. I have the below table: Sprint ID# Description 1 ABC 1 XYZ 2 ...
Ankit's user avatar
  • 11
1 vote
1 answer
84 views

Excel - How do I look up multiple cells from a single reference?

I'm looking to somehow look up a certain amount of cells from a single reference and return them in the same order in another workbook. For example, say I have 5 different SKU codes (these aren't ...
Theo's user avatar
  • 11
1 vote
0 answers
170 views

Using Excel, how can I automate incoming weekly reports/audits to pull data and insert into a new report?

I'm trying to figure out where to start with this so I appreciate any suggestions on something I can do some further research on. My work relies heavily on reports & audits weekly (sometimes ...
Botti's user avatar
  • 11
1 vote
2 answers
364 views

VLOOKUP formula with dynamic address (second parameter), depending on current cell

I need a VLOOKUP that doesn't search the entire range of the column, but from an address that changes depending on the current cell. company1 user1 01/2020 fixed val2 1200,00 fixed ...
Cleiton Oliveira's user avatar
1 vote
1 answer
52 views

Autopopulate a full table

Is there any way of autopopulating a full table in excel eg, when a heading is listed it will bring up a table from another sheet based on the heading? To explain a bit better, I work in a lab and I'...
Lily's user avatar
  • 21
1 vote
0 answers
52 views

How to search for and return all records between two dates?

I'm not sure if this is a lookup formula I need. Basically, I have a huge spreadsheet with the travel details of lots and lots of groups. Each row is a different group. For reference, Column K shows ...
Stephc 's user avatar
1 vote
0 answers
25 views

Excel - Reference Value where multiple conditions are met

I am finding it extremely difficult to translate a simple SQL Style Lookup into excel. I have data spread about multiple excel sheets which I am trying to combine into one sheet/table automatically. ...
Alexander Langanke's user avatar
1 vote
0 answers
16 views

Cannot lookup value and create conditional formatting in excel 2010

I have one worksheet which has in the A column product sku and at C D E columns supplier names. Each supplier has its own worksheet which has again product sku price and availability.(suppliers ...
Maria Georgali's user avatar
1 vote
2 answers
8k views

Using VLOOKUP with data in nonadjacent columns

I have my data stored in and I want to pull a subset of that data based on the selection in a dropdown. For example, if I select "Org 1" in the dropdown, then all the indicator data (Indicators 1-...
Shamiso's user avatar
  • 15
1 vote
1 answer
72 views

Compare excel worksheets

Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files: Subset: This file has a subset of employees with various details including training status such as in-...
Palak Porwal's user avatar
1 vote
1 answer
630 views

vlookup using an =IF formula cell as the reference

I'm trying to use a vlookup where the reference cell is an IF formula: Formula: =VLOOKUP(D14,'Incomplete Report'!A13:C22,3,FALSE) Reference Cell Formula: =IF(A14=$B$11:$B$1079,0,A14) The formula ...
user855088's user avatar
1 vote
0 answers
63 views

Vlookup Assistance

I have a project where I need to lookup up/match multiple values from Column B to match a criteria selected from a drop down list in Column A. The project pertains to different countries and their ...
C Meyer's user avatar
  • 11
1 vote
0 answers
20 views

Auto Update Chart with Data

I want to find a way of pulling data from one table to another. Each week I have a list of new data that I need to place into a master file. The rows have the item and the columns are the week ...
SUPERFLY's user avatar
1 vote
1 answer
74 views

VLOOKUP matching 2 fields

I want to display a value from another spreadsheet based on matches of two adjacent cells. Data where the return value is needed: Data with the values I want to return: I am trying to retrieve ...
Erin's user avatar
  • 11
1 vote
1 answer
60 views

Excel complicated lookup

I have two sheets, one has UPC codes, names, and sizes. The other has a small portion of those names with sizes but no UPCs. I need to get the UPC numbers to fill the appropriate fields. See photo:
Kellie's user avatar
  • 11
1 vote
0 answers
26 views

How do I copy a row of values to another tab if a specific criterion is fulfilled?

I have two tabs with identical tables except one of them is supposed to contain those records that matches one of two values in one of the columns. What I want is that whenever I add a new row to ...
Karol Wawrzyniak's user avatar
1 vote
0 answers
1k views

FAST VBA based vlookup equivalent

Trying to copy the function of vlookup in VBA, the best I can come up with is this: Function VBALOOKUP(LUcell As Variant, LUArray As Range, LUColi As Long, OutColi As Long) As Variant Dim Y() As ...
Some_Guy's user avatar
  • 754
1 vote
0 answers
288 views

Excel: VLOOKUP with cell containing multiple references

I have a table which contains multiple references per cell separated by a blank space. In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the ...
AdrienNK's user avatar
  • 123
1 vote
1 answer
222 views

vlookup + if command

I am a newbee excel user and need assistance in compiling an Excel formula. I have basic IF functions down and Vlookups. I need assistance in combining the 2. I need the formula to read: if CELL L2 ...
Rico Sandoval's user avatar
1 vote
0 answers
752 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 ...
doctorate's user avatar
  • 153
1 vote
0 answers
994 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 ...
user2686410's user avatar
1 vote
1 answer
147 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, ...
Ali's user avatar
  • 11
1 vote
2 answers
251 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 ...
Amanda's user avatar
  • 11
1 vote
0 answers
34 views

Speeding up Vlookups

When you do a Vlookup on a large database of say 80,000 rows, its gets slower and slwer as weach time it starts from the top and works through til it finds it. If its ordered then the first time its ...
Evan Ainsworth's user avatar
1 vote
2 answers
191 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. ...
CHARAN SAHITH's user avatar
1 vote
0 answers
50 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 ...
user320051's user avatar
1 vote
1 answer
217 views

Is there something better than VLOOKUP?

I'm wondering if there is something like a VLOOKUP for multiple matches in one column. So, for example, if I have the following: Alfred red Jone orange Christina blue Danielle blue ...
supercheetah's user avatar
1 vote
1 answer
289 views

Excel access.Vlookup? IF?

What I am looking to do, is to move stuff from one excel sheet to another sheet, in the same workbook. We will call the sheet with the data the "suppliers list" and the sheet where I want it to go, ...
Ted Ogden's user avatar
1 vote
1 answer
149 views

Excel fomularbar shows correct Value, Sheet shows VALUE error

Here is the data I have been using, data format all General: Name Address Adam 250 Mohame 150 Adam 220 Adam 423 Yasir 240 Ibrahim 236 Adam 242 Index formula cell B11 contains the ...
Adam Arsh's user avatar
1 vote
1 answer
341 views

Excel 2007, Vlookup using a table to determine what to return

I want a pretty complicated puzzle and I'm not entirely sure it is possible, I would like to try and avoid making a macro and just use the functions but... I want to have a table of information, 1 ...
DKACyclone's user avatar
1 vote
2 answers
646 views

VLOOKUP, If exists use other value

Sorry, not too good with Excel, but what I am trying to achieve is this vlookup located in sheet1 cell R7: =VLOOKUP(F2,config!F2:H20,3,FALSE) Which displays a room number, e.g. 1 However, if the ...
user1472266's user avatar
0 votes
1 answer
15 views

Count number of times 2 words appear in cells

can someone help me. I am looking to count how many times 2 words appear in a column full of job titles. For example I want to know how many Programme Managers there are in column D. Job titles in ...
Maggie's user avatar
  • 1
0 votes
0 answers
49 views

Excel Vlookup Where Column to Search is identified in Preceding column

I am trying to figure out if there is a way to write a formula such that the Table_Array of a vLookup is based on a value from another column. Basically, I want the Vlookup to search on another sheet ...
bpep's user avatar
  • 1
0 votes
0 answers
18 views

Using excel to reference other workbooks, but using a cell to tell excel which other workbook to reference

I am trying to input data into a cell, and have the cell next to it reference data in a separate file to tell if if there is a match in a specific column in that other file. The goal is to use this ...
Andrew's user avatar
  • 1
0 votes
1 answer
34 views

How can I perform a VLOOKUP by updating only the newly added data each month in a main database while preserving the previously looked-up information?

I have 2 tables, the main data base with data that gets added monthly, with a name, date and corresponding rating. I also have a lookup table that has names and rating of that person, the rating of ...
Delieybee Chauke's user avatar
0 votes
1 answer
53 views

Using a ~ tilde in a Vlookup excel formula

How would I use a Vlookup with multiple tildes in the text string? It would look something like this: SWBC ~ 7797_Dodge_Challenger ~ Video ~ New What would the VLookup formula be?
SO Analytics's user avatar
0 votes
0 answers
41 views

Vlookup with radar graph

i have a simple radar graph setup, 1 column for headings and 1 column for results. The graph works as normal until… Id like the ‘results’ column to be auto filled using a simple vlookup formula. Such ...
Robious's user avatar