**3**

votes

**1**answer

772 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

786 views

### How do I align two tables based on a unique column with Excel?

I have two tables in excel, the first is a complete list of products with some basic info, the other has only selected products in and more information about them, but is lacking some of the ...

**2**

votes

**1**answer

251 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

50 views

### VLOOKUP for latest non-empty cell

Basically, I've got the following spreadsheet.
There are dates along the top. I do a certain amount of past papers each week, and record the highest score I get in a week in cell (paper, week). The ...

**1**

vote

**1**answer

34 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

**1**answer

380 views

### Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...

**1**

vote

**1**answer

255 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

92 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

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

**0**

votes

**1**answer

27 views

### VLOOKUP assistance: match column with column on another sheet

I have a fairly simple VLOOKUP Question but I'm comically horrible with Excel.
Basically, I have two spreadsheets. I'm wanting to find data from Column B of Sheet 2 on Column W from Sheet 1. If the ...

**0**

votes

**1**answer

36 views

### Need to extract multiple matches from a list of values

I am trying to extract data from a worksheet using an array formula but it will only return one (the first it finds) value. The formula I am using is:
=INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ROW($...

**0**

votes

**1**answer

47 views

### Explanation for a VLOOKUP formula used in a Conditional Formatting rule

I have the following VLOOKUP formula for a Conditional Formatting rule:
=VLOOKUP(A1,Sheet1!$A$2:$C$17,3,FALSE)<>0
This works fine and does what I want, which is this: If column C (3rd column) ...

**0**

votes

**1**answer

53 views

### Excel 2013 vlookup & sum

I have a data set which shows test results, each person my have several rows of data. My labels are
ID - Test Date - Test Result - Interval Between Tests
I want to sum the interval between tests ...

**0**

votes

**1**answer

58 views

### finding two adjacent cells using vlookup()

In preparing my data for an interpolation within an interval, I am using the MS Excel vlookup() function to find a pair of values that will define the interval for my interpolation.
The default ...

**0**

votes

**1**answer

42 views

### Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another

I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...

**0**

votes

**1**answer

36 views

### VLookup function solution requested

I have an excel spreadsheet which has got all the data. Column A has the staff initials such as AA, SH, SG.This goes down the column. All other columns there are various data such as fees, amount ...

**0**

votes

**1**answer

315 views

### Build a lookup query in Excel using named ranges stored in a cell

I have a spreadsheet which has a lot of named ranges, each of which is a table. I want to be able to run a lookup that will retrieve a value from any of the tables. I want to be able to store the name ...

**0**

votes

**1**answer

96 views

### Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well.
The ...

**0**

votes

**1**answer

34 views

### in ms excel, is there a way to look up an array and edit data on the looked up row?

Just for a quick example, I have this table:
A B
1 student grade
2 john 90
3 paul 93
4 peter 87
5 bill 84
6
7
Range or array is A2:B5.
I ...

**0**

votes

**1**answer

95 views

### Using vlookup / index match for this circumstances

I have some data which are grouped like this:
1st group of data(gender): Male, Female
2nd group of data(age): 12,13,14,15
3rd group (score + grade): For each gender and their corresponding age, ...

**0**

votes

**1**answer

55 views

### How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns:
ID | Name | Semester | SemesterAvg | Overall Avg | Period |
1 | John | 1 | 2.5 | 2.5 | 20132 |
1 | John | 2 | 3....

**0**

votes

**1**answer

205 views

### Can I use VLOOKUP to return a table name that is then used in an INDEX formula?

I have an INDEX formula like this:
=INDEX(Data3,MATCH(G4,Sheet2!$A$14:$A$17,0),VLOOKUP(F4,Threshold,2,TRUE))
However, I want to apply this to data where the table I want the INDEX formula to ...

**0**

votes

**1**answer

182 views

### Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets
Sheet 1 contains 2 columns.
Column A has a range of unique alphanumeric identifiers.
Column B has a range of non-unique numbers.
A B
...

**0**

votes

**1**answer

117 views

### merge two exel sheets and update duplicate value

I have two exel sheets and I need to merge this sheets but in sheets 1 i Have 800 records in sheet 2 i have 20 records and some of value from sheets 2 are duplicated in sheet 1. I wan to update ...

**0**

votes

**1**answer

247 views

### Copying VLOOKUP formula in multiple sheets, where sheet number automatically changes

I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered ...

**0**

votes

**1**answer

655 views

### Excel: How to find a range, from a list of ranges, that a value is in?

I hope someone can answer my question!
I have lots of values and need to know which ones lie within a list of ranges and if so which range do they lie in.
For example: worksheet 1 contains my ...

**0**

votes

**1**answer

185 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

**1**answer

371 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

131 views

### sum values based in agent ID

I have a sheet with agent id's in column a and under each ID is a sub identifier with a value in column b of 1 - 7
sub identifiers are
Break_1000
Meeting_2000
Training_3000
Personal_4000
...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

126 views

### How to use match & index or lookup function based on a number derived from a time calculation

I have created a gantt chart to use as part of my rota system. I want to be able to use a formula (either LOOKUP or MATCH & INDEX) to look up the hours worked against another sheet and pull in the ...

**1**

vote

**0**answers

16 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

33 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

**0**answers

27 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

**0**answers

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

**0**

votes

**0**answers

29 views

### Function To Lookup Values From Pivot Table

I have been trying to use VLOOKUP() to return values from a pivot table but all I ever get is #Ref I tested my theory that the issue is the fact that I am trying to return the data from a pivot table ...

**0**

votes

**0**answers

17 views

### Two identical values not treated equally in Excel

Was trying to use a simple VLOOKUP on a table with some calculated values (using formulas). It couldn't do exact match, even though the lookup value is equal to the table value. But copying the needed ...

**0**

votes

**0**answers

6 views

### Trying to augment Vlookupall VBA to only return unique values

Am trying to augment the below code to only return unique values. I am currently using this to create a type of picklist where for a given item it returns all of the storage locations that the item ...

**0**

votes

**0**answers

18 views

### I am looking to reverse lookup missing numbers from a VLOOKUP in Excel

Hi please let me know if this is a duplicate but I did a brief search and did not find anything that wasn't a ton of code that I couldn't relate back to my spreadsheet.
I have excel 2003-2007.
I ...

**0**

votes

**0**answers

25 views

### Extracting a Sublist from Master List

How do I write a formula to find the exact matched of the subsets and extract it from the master?
Basically what I have is a master data spreadsheet of 275,000 rows of data. I then have a queried ...

**0**

votes

**0**answers

43 views

### How to keep a Value in Excel (constant value)

I have set up a formula,
=IF(T74="1/2Dry Stack",0.1,IF(T74="DryMortar Joint",-0.1,0))
Linked to a drop down list on another sheet. How can I keep the value of the formula after making another ...

**0**

votes

**0**answers

25 views

### How do I IF & VLookup?

How do I ask IF the cell is found in another table pick the cell information next to it in the other table?
I know this is an IF and Vlookup formula, but I'm not getting the If statement correct ...

**0**

votes

**0**answers

42 views

### Vlookup stopped working when I changed the lookup cell reference

I have a case where I need to change the lookup value reference in a Vlookup but I can't get the new formula to work.
Old Formula:
=IF(IFERROR(VLOOKUP($CQ2;'TrackerStatus TRO'!$A$2:$BG$65536;2;...

**0**

votes

**0**answers

52 views

### Conditional formatting to highlight differences between 2 pivot tables in Excel

I have an Excel issue I hope somebody may be able to help me with please?
I have 2 pivot tables that both contain the following fields:
'Provider ID' in the Rows area,
'Month' in the Columns area ...

**0**

votes

**0**answers

38 views

### Find and Replace in .txt file by extracting data from spreadsheet

I need to replace instances like Manhole Name="1" with Manhole Name="SW3/001" for instance by extracting the data from spreadsheet.
Would that be possible using regex, or in any possible way ?
...

**0**

votes

**0**answers

56 views

### Excel vlookup in two access tables

What i want to do is use vlookup in Excel with data from two tables in Access. Vlookup will search for a first/last name field into both those tables and return info from them. I can't seem to find a ...

**0**

votes

**0**answers

118 views

### Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following:
Sheet1
Fruit______ Orange_Apple_Banana
...

**0**

votes

**0**answers

152 views

### Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...

**-2**

votes

**0**answers

28 views

### Matching data from two different worksheets

I'm hoping someone can help me with the following:
I have two separate Excel worksheets - The first sheet is a master list of contacts including their address/zip, and the second sheet is a list of ...