21 Quick replace #N/A by 0 when vlookup 2012-03-05T15:21:17.797

20 Excel - How to vlookup to return multiple values? 2013-01-14T21:43:56.483

11 Excel VLOOKUP by second column using table name as range 2013-09-13T18:55:19.043

11 How to get VLOOKUP to return the *last* match? 2014-07-11T18:46:53.363

8 Working with "~" in excel 2013-06-03T18:55:04.877

8 Searching for a value in Excel, returning yes or no 2014-05-21T20:08:24.160

6 Extract values from a range that are missing from another 2012-05-31T03:16:23.647

6 Excel INDEX MATCH Checking Multiple Columns 2016-05-18T09:18:18.673

5 How do I prevent VLOOKUP from breaking after I add a column to a named range? 2011-08-11T18:07:20.020

5 In Excel how can I search for #N/A cells? 2016-07-10T07:55:02.963

4 Excel vlookup reference purposely missing shows #N/A - stop it 2016-05-21T18:41:39.683

4 How can I combine VLOOKUP within an IF statement where the column index of the VLOOKUP function is a number extrapolated from a text? 2017-05-02T09:43:16.940

3 255 Character limit on VLOOKUP 2011-02-18T11:19:48.407

3 How can I VLOOKUP in multiple Excel documents? 2012-10-13T08:33:30.267

3 Excel: Why is VLOOKUP returning inconsistent and unexpected results? 2013-02-20T16:19:16.010

3 How do I prevent vlookup returning 0 for values that are blank in the lookup data? 2013-03-25T04:27:45.483

3 Excel: VLOOKUP and INDEX+MATCH return #REF 2013-06-21T12:07:14.073

3 Excel, how to use text functions on lookup array without putting in another column? 2015-05-21T09:08:28.207

3 Return list of all values that match criteria 2017-01-19T16:04:47.183

3 Single named range over multiple sheets in same Excel file? 2017-06-29T18:20:19.313

3 Lookup based on three criteria 2018-01-15T00:05:22.573

3 Excel lookup value within 3 columns and return value from 3rd columns? 2018-01-23T11:37:15.537

3 Excel partial look up function? 2019-04-21T19:53:56.100

3 Return list of all values that match Two criteria 2019-07-31T05:08:50.223

3 I want to count IF both condition are true Logically count by AND excel 2019-10-31T07:21:06.060

2 Excel 2010 - VLookup, Search and Match are doing things beyond my imagination 2013-03-20T09:51:56.797

2 Excel - matching values in columns in different tabs and then pasting into another column if there's a match 2013-03-01T16:16:58.837

2 WHERE in vlookup? 2013-06-18T10:56:01.857

2 Excel VLOOKUP using results from a formula as the lookup value 2013-10-25T16:11:36.360

2 Not getting desired output with VLOOKUP - Need assistance 2015-06-10T08:14:34.377

2 VLOOKUP - return multiple values/columns for one row/match of data 2015-06-24T20:08:11.370

2 How do I align two tables based on a unique column with Excel? 2015-07-07T20:04:32.393

2 Making one list from other data using a lookup 2015-09-16T16:31:53.120

2 Excel - return multiple values for each of a list of values 2015-10-01T07:55:01.277

2 Build a lookup query in Excel using named ranges stored in a cell 2015-10-12T22:45:22.870

2 VLOOKUP and IF in multiple excel sheets 2015-12-07T22:51:54.210

2 Range mapping in Excel 2016-01-26T23:43:55.163

2 Excel Vlookup Error for Some of My Text 2016-05-04T17:55:11.917

2 Using INDIRECT within VLOOKUP 2016-06-10T07:16:38.400

2 Excel - vlookup with priorization 2016-09-29T09:49:27.233

2 vlookup using two columns names in different worksheets 2017-03-14T05:47:25.143

2 VLOOKUP or INDEX-MATCH formula for database 2017-04-24T16:42:51.320

2 Is it possible to use Index and Match or something similar in Microsoft Excel to find last filled number row for two sets of numbers in same column? 2017-05-28T17:31:43.283

2 Using VLOOKUP to retrieve data in separate sheet based on value 2017-07-13T19:19:01.743

2 Excel: Multiple column lookup and count 2017-10-08T20:56:03.473

2 How can I lookup a value in a column for multiple rows? 2017-10-23T21:53:33.343

2 Creating a repeating vlookup table for raw materials 2018-03-08T05:43:58.133

2 Excel - Increment vlookup column index when dragging down 2018-04-26T08:09:09.677

2 Lookup value in a row based on keyword 2018-06-16T11:44:31.650

2 Return and sum multiple values using a wildcard criteria 2018-06-29T03:56:57.860

2 VLOOKUP() to a Table on a different worksheet returning an #N/A error 2018-06-29T23:31:26.280

2 Excel VLOOKUP function giving the incorrect value. Can somebody identify mistake? 2018-09-08T23:38:25.757

2 Excel Formula CONTAINS 2018-12-28T00:46:04.037

2 Using VLOOKUP for multiple lookup values, then summing the outputs 2019-01-29T00:00:23.407

2 How to use proportions with lookup tables in Excel? 2019-02-11T18:34:47.107

1 MS Excel 2010: VLOOKUP not working right? 2011-02-22T09:44:28.253

1 Excel IF and VLOOKUP function help 2011-08-04T19:43:38.563

1 How do I perform a lookup of non-unique items, with a condition to decide which to return? 2011-09-14T19:14:55.580

1 Autoincrement the VLOOKUP column index in Excel 2012-01-31T06:35:10.607

1 Edit referenced cells in master worksheet from derived worksheet in Excel 2012-05-01T21:45:20.087

1 In Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself? 2012-06-06T13:41:19.273

1 How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel? 2012-06-20T16:00:49.853

1 Excel 2007, Vlookup using a table to determine what to return 2012-07-01T15:16:59.493

1 Formula to merge column from sheetA to sheetB to matching ID 2012-09-11T02:31:21.160

1 Vlookup using wildcards in indexed column 2013-01-28T23:16:53.000

1 Looking-up the values of one worksheet in another worksheet 2013-03-04T19:05:05.920

1 Excel #NA error returning TRUE 2013-06-10T17:54:03.510

1 Forcing consistent format for lookup values and lookup arrays 2013-06-13T08:31:53.427

1 Excel fomularbar shows correct Value, Sheet shows VALUE error 2013-08-29T07:48:15.233

1 Lookup list dependant on the contents of another cell 2013-09-19T09:19:43.123

1 How to join two worksheets based on the data they contain 2013-10-22T07:36:55.153

1 Excel access.Vlookup? IF? 2013-10-25T11:45:31.533

1 Lookup range of words in range of sentences 2013-11-20T08:48:47.630

1 Converting Monthly Data to Daily Data on Excel for Mac 2014-01-14T03:03:27.043

1 Excel: return name of column with highest value in a non-continuous array 2014-01-17T18:00:20.403

1 vlookup with blank look up value 2014-02-27T16:15:55.737

1 In Excel 2011 on Mac, how to return a non-blank matching value with vlookup? 2014-04-07T18:58:39.933

1 Trouble adding values from different ranges in excel 2014-05-03T00:38:08.383

1 VLOOKUP not interpolating all cells? 2014-07-21T13:25:00.337

1 Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value 2014-08-18T20:34:42.777

1 Searching a value in a column in Excel 2014-09-19T06:25:14.030

1 Lookup returning #n/a - would like cell to be blank 2014-09-25T20:44:09.807

1 VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table 2015-01-12T21:58:22.327

1 How to CONCATENATE a VLOOKUP and have the lookup take place without an CR after a copy and paste value 2015-02-19T19:56:00.317

1 I need the number in a cell to countdown when data is entered into other cells. 2015-03-23T14:08:17.073

1 Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel 2015-07-07T13:30:13.360

1 Speeding up Vlookups 2015-07-10T07:35:20.163

1 Excel Sort and Lookup Values Formula 2015-09-10T05:29:48.863

1 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? 2016-02-12T23:13:14.623

1 Look up specific word in a table array and return adjacent cell 2016-03-16T06:21:41.917

1 VLOOKUP for latest non-empty cell 2016-03-21T08:55:01.300

1 Storing numbers as text for VLOOKUP 2016-05-13T20:21:34.323

1 What's VLOOKUP's true algorithm with range_lookup set to TRUE? 2016-06-09T20:12:44.653

1 Why VLOOKUP () doesn't work in this example in LibreOffice Calc? 2016-06-30T11:58:24.603

1 Referencing a dynamic, named range between workbooks 2016-08-01T21:15:59.240

1 vlookup + if command 2016-08-02T06:15:52.877

1 Excel: VLOOKUP with cell containing multiple references 2016-08-18T08:51:57.963

1 FAST VBA based vlookup equivalent 2016-09-22T09:59:36.720

1 How can I match values based on criteria? 2016-10-17T23:11:06.000