All Questions
Tagged with excel-2007 vlookup
34 questions
0
votes
2
answers
299
views
Merge two tables into one pivot chart excel
Having two tables with the following data (with 0 representing sad and 1 happy)
I need to have one graph for the two tables.
The IDs are unique for each table.
I tried implementing it as two different ...
- 13
0
votes
1
answer
46
views
How to Vlook up this in Excel
I have reference Id and timestamp columns in sheet 1 and sheet 2. Reference Id in the both the sheets are same but not in the same order and timestamp is different in both sheets. What I want to do ...
- 303
0
votes
1
answer
113
views
Excel vlookup table array
Please forgive me if the formula isn´t correctly translated as my Excel is in Spanish.
=IF.ERROR(VLOOKUP(B3;[17.01.2017.xlsx]Hoja1!$A$2:$B$29;2;FALSE);"")
What I need is to get the date from the ...
- 1,671
1
vote
3
answers
248
views
Copying excel data from one sheet into another sheet
I've been searching for this on google but no luck. I have multiple sheets in my excel workbook, and one sheet as a 'summary' page. I want the data from the other sheets to update in my summary page....
- 13
0
votes
2
answers
51
views
Dynamic reference in vlookup
I have a formula like this:
=VLOOKUP(A14,Cars!C25:S49,17,0)
I would like to know if the below is possible:
The numbers 25, 49 which are specified in the Range of the above vlookup were present in ...
- 1,461
1
vote
1
answer
141
views
Nested IF formula with VLOOKUP
In cell D5:
=IF(VLOOKUP(C5,'store1'!$F$4:$F$29,1)=C5,"store1","")&(IF(VLOOKUP(C5,'store2'!$F$4:$F$29,1)=C5,"\store2","")&(IF(VLOOKUP(C5,'store3'!$F$4:$F$29,1)=C5,"\store3","")&(IF(VLOOKUP(...
- 13
-2
votes
2
answers
59
views
Conditional results based on average found from other cells [closed]
Rather than an Excel formula of this kind:
=IF(AVERAGE(A1:A4)<4,"POOR",IF(AVERAGE(A1:A4)<5,"Meet Expectation",IF(AVERAGE(A1:A4)<7,"Good",IF(AVERAGE(A1:A4)<8,"Excellent","Outstanding"))...
- 13
1
vote
2
answers
262
views
Multiple value lookup accross excel sheets
I have a master worksheet and a Extract worksheet.
I want to extract data from Extract sheet and present it as follows in the master sheet.
Data is as follows:
Extract Sheet
-------------------------...
- 33
0
votes
1
answer
132
views
Cell match and compare
I have four columns structured like so:
Column A: Data title for metric.
Column B: Corresponding metric for data title in Column A.
Example:
Row 50 |BlahBlah | 5 |
Column C: Same as Column A ...
- 65
0
votes
1
answer
56
views
vlookup generates #N/A and correct data as well
While using vlookup within the same Row, some of the cells generate correct results but some of them generate #N/A. All the source data is correct in the sheet from where I'm taking it.
The generated ...
-5
votes
5
answers
1k
views
VLOOKUP and merge sheets to one file
I have three Excel sheets, with some similar column headers:
sheet1:Id | tax | amount
34 23% 2300
sheet2:Id | rate | ...
- 3,648
0
votes
1
answer
65
views
If the cell has a number then return the cell next to it in a sorted way - Excel
The picture attached here is my daily work sheet where blue cells show the works I have to do.
As shown, there is numbers in front of the blue ones which are the priority of the tasks.
What i want:
...
- 91
1
vote
1
answer
43
views
lookup in excel 2007 over extended range
I have a spreadsheet with sorted information in the following form:
name col1 col2
AAHEIM 1 2
AAHEIM 1 2
AAHEIM 9 3
AAHEIM 7 7
AAHEIM ...
- 153
1
vote
1
answer
1k
views
SumProduct and VLookup for selected columns
I have a function that reads:
=SUMPRODUCT(VLOOKUP(D17,'D:\Temporary Storage - not backed up and unsecured\[PT current plan.xls]Ore Fines'!$A$12:$BC$146,{4,8,12,16,20,24,28,32,36,40,44,48,52},FALSE)+...
- 153
0
votes
1
answer
169
views
sumproduct and vlookup returning an error
I have a function that reads:
=SUMPRODUCT(VLOOKUP(D261, '[IJM current plan.xls]LO calcs'!$AU$12:$BO$147,{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21},FALSE)+VLOOKUP(D261,'[IJM current plan....
- 153
1
vote
1
answer
4k
views
Formula to determine USPS Postal Zone based on ZIP code
I'm looking to make the sorting of hundreds of envelopes by USPS postal zones easier. The difficulty is in having to manually sort them for each of the 8 US zones, based on the origin ZIP code: 91352.
...
- 11
0
votes
1
answer
2k
views
Understanding the vlookup formula in Excel?
I have two lists in the spreadsheet and some of the names match and some do not.
I need a formula so that where the text matches it can assign the corresponding value.
For example: in B2 it would ...
- 11
0
votes
2
answers
472
views
Incorrect using vlookup formula
I have in excel one table:
AAl 1
AAr 2
Abu 3
and the second
AAl
AAr
ABa
ABe
ABu
I would like have the same numbers in second table as in the first table. I am using vlookup formula:
=VLOOKUP(...
- 829
1
vote
3
answers
2k
views
Create matrix from multiple values in a single cell
I have data like this in Excel:
that I want to convert to a (5*7) matrix like this:
sara jone shery jack joe peter beti
book1 1 0 0 0 0 0 ...
- 255
0
votes
1
answer
350
views
Vlookup with a condition returns #N/A for matched data [closed]
I am trying to create a vlookup with a condition, link. All combinations are unique, so Chicken - Sausage will only appear once. I have checked my formula and this is what happens;
Formula checks ...
- 10.1k
3
votes
1
answer
35k
views
VLOOKUP text inside a string
I have a column DeviceName in Sheet1 and it contains data like RTRNY653, SWNY653, ... In Sheet2 I have a column InterfaceName and it contains interface names and at the end the device name is listed ...
- 10.1k
0
votes
1
answer
792
views
Excel VBA Lookup Methods
I have an issue that I've been scratching my head at; I've looked into the Index:Match lookup method, and V/HLookup, but I'm not sure these will help just yet. Here's what's happening:
I have two ...
- 474
0
votes
2
answers
323
views
A formula to Find/Replace mobile telephone numbers in text format
I have a column where I input mobile telephone numbers. Here's sample input for Column A (text format):
+639154112315
+639171214125
+639179120519
I have a column (B) where I input mobile ...
- 83
1
vote
1
answer
2k
views
Highlight cell when dropdown selection matches one in list
I have an Excel sheet I'm working on and I need to highlight a cell (with a dropdown) when it matches a text value in a list of specified text values. I understand conditional formatting but no matter ...
user2096457
0
votes
1
answer
2k
views
Grouping rows by area codes
I have a table of customers to which my company ships products. The problem is that these customers need to be sorted by their area codes, so that the products can be sent to the appropriate shipping ...
- 706
0
votes
1
answer
167
views
Programming with VLOOKUP or IF statements
I am trying to take column a (5000 rows) and match against column b (138 rows) and when it finds a match in cell b will take cell c (on the same row) and print it in cell d for example. I have ...
0
votes
1
answer
66
views
Issue with Array in Vlookup [Excel 2007]
I have an issue with vlookup recently when trying to compare 2 tables.
it seems that no matter what i did the end result is always "#N/A"
My goal is to find out the if the overlapping entry in both ...
2
votes
1
answer
103k
views
Excel- compare two cell from different sheet, if true copy value from other cell [closed]
So, I have a worksheet A and worksheet B.
I would like to compare column A on both sheets with each other.
If the value is the same (true), than copy value from worksheet B, from column F (this ...
- 905
0
votes
1
answer
2k
views
How to get the corresponding values of the latest date in Excel?
I have this values in my excel:
A B C D
StaffId FSales ESales Date
1 100 500 23-Jan-13
1 50 170 25-Jan-13
1 ...
- 909
1
vote
2
answers
187
views
Need advice on VLOOKUP, LOOKUP or MATCH
I have four columns Name, Y/N, NameList and Result, e.g.:
A B C D
Name Y/N NameList Result
Abc Y Xyz N
...
- 909
0
votes
1
answer
2k
views
Vlookup entire row
I want to search an entire row using Vlookup from another sheet in my workbook. Currently I can only fetch the Name using excel. With sample data & searching for 123
Sheet 1
ID Name ...
- 13k
2
votes
2
answers
13k
views
Why is VLookup in VBA failing with runtime error 1004?
Spreadsheet "Sheet3" looks like this:
S&P 500 DJIA
1/1/1991 795.4476 2973.09
1/2/1991 786.3856 2947.1
1/3/1991 775.4636 2905.19
1/4/1991 773.5364 ...
- 649
0
votes
2
answers
4k
views
Major formatting issue in Excel - VLOOKUP
I need help with a formatting issue in Excel, which is interfering with the VLOOKUP function in my Excel sheet.
I have two sheets with more than 20,000 column values as lookup, and the same number ...
- 357
3
votes
5
answers
12k
views
Excel - Recursive VLookup
I recently came to know about Ctrl+Shift+Enter array formulas of Excel and currently still learning them. Coming to my problem,
SheetA:
Product Code
S1 19875
S2 19834
...
- 1,074