**3**

votes

**2**answers

71 views

### In Excel how can I search for #N/A cells?

I'm trying to go to the first instance of a #N/A cell, the result of a VLookup that failed.
I know I can conditionally change the value when the result is #N/A, but what I want to do is just locate ...

**0**

votes

**0**answers

33 views

### Excel - Keeping Original Cell Value with VLookup and Iferror function

I am stuck with a Vlookup formula I'm working with. I need to apply the vlookup formula to a whole column, but here's the catch - I need the formula to not do anything if it returns an error. There ...

**1**

vote

**2**answers

50k views

### Excel - matching values in columns in different tabs and then pasting into another column if there's a match

I have an Excel worksheet with two tabs, Tab 1 has a list of employees with information on different courses they've taken. Among them is a tab with a 5 digit employee ID to easily identify them..
...

**0**

votes

**1**answer

56 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

32 views

### How to optimize fields that has “if” function which return blank value on Excel?

Here is the screenshot, it's only an example since I can't post the original one:
I made this worksheet to cross-check the employee present with another sheet that has information whether this ...

**1**

vote

**0**answers

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

**-4**

votes

**1**answer

107k views

### How do I compare two columns in Excel to find if there is corresponding data?

How do I compare two Excel sheets to detect whether the data in column B of sheet 2 appears in column A of sheet 1?

**1**

vote

**1**answer

17k views

### VLOOKUP - return multiple values/columns for one row/match of data

I'm trying to figure out how to pull multiple columns to my target sheet when using VLOOKUP. for example
I have a list of employees on sheet one, with 100 rows of data and want to pull details about ...

**0**

votes

**3**answers

134 views

### Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...

**2**

votes

**1**answer

33 views

### Using INDIRECT within VLOOKUP

I am conducting a series av tests of data in different excel workbooks. It order to not have to change all Workbook names in the formulas used I find it suitable to use INDIRECT() and refer to a cell ...

**0**

votes

**0**answers

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

**1**

vote

**0**answers

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

**0**

votes

**2**answers

76 views

### Look up table values in different worksheets to create summary (VLOOKUP, HLOOKUP, INDIRECT)

I'm having problems creating a summary cashflow spreadsheet that looks up a couple of references - a date (which is no problem) and a different spreadsheet name (which is the problem).
I have ...

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

**-1**

votes

**1**answer

44 views

### vlookup - Is it possible to use vlookup to pull specific info like this?

I am trying to pull the following from each group of Numbers -
CHG000509443 05-16-2016 22:48:41 for the Requested
CHG000509443 05-17-2016 13:14:35 for the Approved
Note 1 - It is always the first ...

**0**

votes

**0**answers

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

**3**

votes

**2**answers

230 views

### Excel vlookup reference purposely missing shows #N/A - stop it

I have a cell which does a vlookup.
But the table to which it refers is always changing and when the specific value is there is shows fine.
But when the value isn't there it shows #N/A - how can I ...

**0**

votes

**0**answers

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

**6**

votes

**4**answers

510 views

### Excel INDEX MATCH Checking Multiple Columns

The problem I'm essentially trying to solve is a VLOOKUP that is checking Columns A:E for a value, and returning the value held in Column F should it be found in any of these.
With VLOOKUP not being ...

**1**

vote

**2**answers

34 views

### Storing numbers as text for VLOOKUP

I am aggregating a large amount of data from several workbooks and need to cross-reference several thousand items, perfect job for VLOOKUP.
However, all I get is the lovely #NA error.
The issue of ...

**0**

votes

**1**answer

39 views

### Issue to extract data without Vlookup

I have trouble extracting data from a huge file. Until now I was using Vlookup but of course it only takes the first number it finds.
I need to be able to read data in each columns = X,Y,W,Z for the ...

**1**

vote

**1**answer

40 views

### Excel Vlookup Error for Some of My Text

I have an Excel report with web page titles that I am trying to match corresponding page views to using VLOOKUP. The lookup table is a separate Excel file exported from Google Analytics.
When I ...

**11**

votes

**3**answers

115k views

### Quick replace #N/A by 0 when vlookup

I use vlookup a lot in excel.
The problem is with #N/A value when the seek value is not found.
In that case, we often replace it by 0 using
if(isna(vlookup(what,range,column,false));0; vlookup(...

**0**

votes

**2**answers

37 views

### How to make excel SUMUP values of multiple rowkeys in a two-dimensional lookup to return sumed up values in a corresponding cell

So I have this challenge with a set of data arrangement and by merging the VLOOKUP and MATCH strings I was able to get my result but there is a little hiccup!
Pasted below is the merged string that ...

**0**

votes

**0**answers

28 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

**2**answers

357 views

### vlookup with blank look up value

I have a Vlookup formula that I want to return 0 if the returned value is empty.
example:
=(VLOOKUP(A6,F:G,2,0)+1)*C6
+-------+--------+-------+-----------+-------+-------+
| | | |...

**0**

votes

**1**answer

41 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

**3**answers

1k views

### I need the number in a cell to countdown when data is entered into other cells.

I'm making a sheet to keep track of the number of software licenses.
In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total ...

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

**1**answer

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

**6**

votes

**5**answers

12k views

### How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...

**1**

vote

**1**answer

38 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, ...

**0**

votes

**2**answers

4k views

### How to return all the cells in a row if first column matches a value on another worksheet

I have 2 worksheet tabs in an Excel workbook, tickets and tickets info. I have values in Column A of tickets (from A2:A500). I want to search for each value from A2 to A500 of the ticket sheet looking ...

**1**

vote

**2**answers

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

**0**

votes

**2**answers

183 views

### If cell contains “Specific Text” return value of cell beside it. Similar to VLOOKUP

I have 2 sheets, one with a list of parts(sku) and all the vehicles that the part will fit on (fitment) separated by "^^" it looks like this:
sku | fitment
1 |car1 ^^ car2 ^^ car3
2 |car2 ^^ car3
...

**0**

votes

**1**answer

49 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

**2**answers

45 views

### Range mapping in Excel

I have a column of data in Excel with numbers [0..100]. I need a new column, which maps these to a new set of values such that:
> 90 : 4
80-90 : 3
70-79 : 2
60-69 : 1
< 60 : 0
I attempted to ...

**0**

votes

**0**answers

48 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

**1**answer

62 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

**0**answers

26 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

**1**answer

190 views

### How to populate information from one sheet to another in Excel Workbook?

My current task is to create a formula where my information from one sheet will auto populate in another sheet when the product description is copied.
To be specific, we need to have the items ...

**0**

votes

**1**answer

353 views

### When switching to another doc, Function Argument window disappears?

I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears.
Google finds some results about the ...

**0**

votes

**1**answer

26 views

### Using a Date to refer to a page to VLOOKUP into

I currently have data that has a date and item number and I'm looking to pull the price from a different sheet.
=Vlookup(#,Jan1!(Range),2,0)
Gives me my price of Jan 1
=Vlookup(#,Jan3!(Range),2,0)
...

**1**

vote

**1**answer

278 views

### Excel Sort and Lookup Values Formula

I am trying to create some sort formulas on excel.
An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...

**0**

votes

**2**answers

971 views

### Converting Monthly data to Daily data on EXCEL for MAC

I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular month'...

**0**

votes

**0**answers

45 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

61 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

**1**answer

91 views

### Vlookup in Excel returns #VALUE

I am using two worksheets in Excel but am having problems with using VLOOKUP.
Sheet 1:-
ID CATEGORY_ID
Sheet 2:-
CATEGORY_ID CATEGORY_NAME
I essentially want to add the CATEGORY_NAME in ...

**0**

votes

**1**answer

2k 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, ...

**2**

votes

**1**answer

73 views

### VLOOKUP and IF in multiple excel sheets

I have two excel sheets, as below, in a workbook
Sheet 1 & 2:
Below is the relation of fields between the two sheets
EID is same as EmID
DepID is same as DependentID
DepDOB is same as ...