# Tagged Questions

**1**

vote

**1**answer

20 views

### VLOOKUP not interpolating all cells?

My VLOOKUP formula is not interpolating all cells
AD AE AF
11-6-2014 15:20 90,4 #N/A
11-6-2014 15:21 89,1 #N/A
11-6-2014 15:22 90,4 Good
11-6-2014 15:23 89,1 Good
AF column is my ...

**0**

votes

**1**answer

65 views

### Excel SUM From Different Sheets IF Date Found

I have a workbook with separate sheets for each product (about 20 sheets, adding more on a regular basis). Each product is only available for a certain time frame, and has daily sales data recorded on ...

**0**

votes

**2**answers

312 views

### Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...

**0**

votes

**1**answer

45 views

### In Excel selecting an item from row when cell matches the first item in that row

I have a LIST of 5 optional sizes. There are several numbered mating parts that coincide with each of the sizes forming a pair. Any 1 of the mating parts can go with a chosen size, but only 1. Some ...

**0**

votes

**0**answers

54 views

### =VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side.
I want the B2 cell to display the salary ...

**0**

votes

**2**answers

40 views

### vlookup with blank look up value

I have a Vlookup running and I want it to return 0 if the look up value is empty.
example:
=(VLOOKUP(A6,F:G,2,0)+1)*C6
+-------+--------+-------+-----------+-------+-------+
| | | ...

**0**

votes

**1**answer

104 views

### Count instances of a letter in a row if a certain cell in that row contains a specified date

I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date.
I ...

**0**

votes

**1**answer

205 views

### Formula to display text from multiple cells from one sheet in another

I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...

**1**

vote

**2**answers

82 views

### Excel: return name of column with highest value in a non-continuous array

I have looked up many answers to find the highest value in a column, and return the column name. However, every answer is dependent on using a continuous array and uses the INDEX function. This is ...

**0**

votes

**2**answers

388 views

### VLOOKUP with multiple criteria

I have a workbook with 2 sheets: spg and data
From the data sheet I wish to do a vlookup in the spg sheet, based on the value of multiple columns in spg.
I can do a =VLOOKUP(H5,spg!$D:$I,6,0) but ...

**0**

votes

**1**answer

272 views

### Excel 2013: VLookup for cells that share common characters within cell but are both surrounded by other non-matching text

I am pulling information from 2 different databases. The databases use different naming protocol for the exact same item/specified placement however they always have certain components of the name in ...

**2**

votes

**1**answer

104 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 ...

**1**

vote

**1**answer

131 views

### Excel access.Vlookup? IF?

What im looking to do, is 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, the ...

**0**

votes

**1**answer

65 views

### vlookup datetime FALSE; return value from 1 of two columns based on exact datetime

Based on data below, I am trying to do a vlookup such that if the datetime in ends in 18:59 return the value in column_3, if the datetime ends in 6:59 return the value in column_4...
10/7/2013 18:59 ...

**1**

vote

**2**answers

110 views

### Forcing consistent format for lookup values and lookup arrays

I have this annoying issue where I need to look up values in a column that contains both numeric and alphanumeric data. For instance:
1234567
P654321
7654321
V234567
..and so on.
This column is ...

**0**

votes

**1**answer

690 views

### vlookup and indirect and external shared workbooks

i have two excel workbooks that are both shared in our company folder.
excel1 is where each employee has his own page to fill information and column 1 of each page is the row reference
excel2 is a ...

**0**

votes

**2**answers

5k views

### Looking-up the values of one worksheet in another worksheet

Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it.
I have two worksheets in Excel.
Worksheet 1.
Column-A ...

**2**

votes

**0**answers

303 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**

vote

**4**answers

1k views

### Vlookup using wildcards in indexed column

I know how to use a wildcard with Vlookup on the reference value, but what about on the matched column index?
I know you can do for instance VLOOKUP("*Hello*",A4:G4,2,FALSE)
However, what if you ...

**1**

vote

**2**answers

157 views

### Formula to merge column from sheetA to sheetB to matching ID

Match unique id Sheet1!A2 to a cell in Sheet2!A2:A100 that has the matching ID.
Paste cell content from column Sheet2!C2:C100 from the same row with the matching id in Sheet2 to the cell with formula ...

**0**

votes

**1**answer

10k views

### Apply VLOOKUP formula to multiple sheets

How can I apply a VLOOKUP formula to multiple sheets in Excel 2010?
Our formula is written and it is working on our Sheet 1, but we need to search 3 Sheets (within the same Workbook), preferably ...

**1**

vote

**1**answer

129 views

### In Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself?

Simple question and more than likely a simple answer.
I have a workbook with a few worksheets, one of which is a 'data' worksheet. This information is utilized on another worksheet 'main' to fill in ...

**0**

votes

**2**answers

287 views

### Can an array input be used in the sheet name of vlookup's range?

I have a formula which works, but is absurdly long, but repeats the core data over and over.
My spreadsheet contains 70 pages describing sets of cards. The page I'm working on gives me a particular ...

**1**

vote

**1**answer

4k views

### Excel IF and VLOOKUP function help

The exercise is to use IF() and VLOOKUP() functions to return the tax rate based on the annual income and number of people in the household.
So far I've tried inputting:
...

**0**

votes

**1**answer

149 views

### Excel vlookup help

=IF(N101<>"",ROUND(VLOOKUP($N101,$I$30:$U$39,12,FALSE)/(1-(U$96+U$98)),0),0)
That is the current VLOOKUP in the spreadsheet that is returning the wrong data. I didn't write it, it was on a ...