All Questions
Tagged with worksheet-function vlookup
75
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 ...
- 1,799
2
votes
2
answers
294
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 ...
- 21
2
votes
1
answer
199
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),"")
...
- 21
2
votes
1
answer
950
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 ...
- 21
1
vote
1
answer
38
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 &...
- 11
1
vote
1
answer
5k
views
VLOOKUP and HLOOKUP combo
I am struggling with the following (see snapshot) and I can't understand what I'm missing.
If the id matches, I would like to extract the value of that id in when the values in col2 matches the ...
- 111
1
vote
1
answer
386
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 ...
- 11
1
vote
1
answer
92
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 ...
- 11
1
vote
0
answers
200
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 ...
- 11
1
vote
2
answers
402
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 ...
- 111
1
vote
0
answers
26
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
1
answer
73
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-...
- 11
1
vote
1
answer
638
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 ...
- 11
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 ...
- 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:
- 11