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
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 ...
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$...
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 ...
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),"")
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 &...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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'...
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 ...
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. ...
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 ...
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-...
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-...
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 ...
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 ...
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 ...
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 ...
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:
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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. ...
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 ...
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
...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...