Comments on: Advanced VLOOKUP in Excel: multiple, double, nested

In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOKUP functions in one formula, dynamically pull data from different sheets, and more. Continue reading

Comments page 14. Total comments: 540

  1. I want 0 inspite of #N/A when ever vlookup comes up with no value (& there is also actually not any value against that respective reference).Can you kindly tell me how can I get that. I used If(iserror also but it brings "Blank" cell when there is #N/A but our requirement is 0.

    Help is greatly appreciated

    1. Hi Assad,

      You can use the IFNA function with 0 in the second argument, like this:
      =IFNA(VLOOKUP(), 0)

      If you want the formula to bring 0 instead of any errors, not only #N/A, then use the IFERROR function:
      =IFERROR(VLOOKUP(), 0)

  2. Hello,
    Can you explain how to get all Duplicate values in a lookup range, looking up values in a different worksheet(of the same workbook)?

  3. Hi!

    This was very helpful.
    If i want the multiple results to be displayed in columns how will i do it with this?

    {=IFERROR(INDEX($C$2:$C$16,SMALL(IF($F$2=B2:B16,ROW(C2:C16)-1,""),ROW()-3)),"")}

    Thank you!

  4. Thanks for the great post. Nevertheless, I have been presented a problem to interpolate in a given lookup "string" which is concatenated a "value" . As an example :

    The string here would represent the pipe name, value is the pipe number, value2 represents the depth and value 3 is the x-coordinate.
    --String Value Value2 Value 3
    Pipe 1 200 50
    Pipe 1 210 60
    Pipe 2 200 45
    Pipe 2 250 60
    Pipe 3 150 50
    Pipe 3 200 55

    I'd like to create a lookup function which I can not only identify but interpolate the x-coordinate (value 3) at a given pipe depth (value 2) and pipe identification (String and value) .

    Naturally I have tried to use combined "helper" (=Pipe&3&150) but unfortunately excel treats this a string but not values. This can only work if I provide the exact depth which would return the exact coordinate value on the table.

    Any advice, my respected excel gurus?

    1. Izwan,

      For us to be able to assist you better, please send your sample workbook with the source data and expected result to support@ablebits.com. I am sorry, at the moment it is not very clear why you need interpolation.

  5. I am trying to use Vlookup in pulling out the grades from a transmutation table. Column A is the lookup value and column B is the equivalent grade. The values in A begin with 0 and increments of 0.01 while column B begins with 60. When this formula is used: =VLOOKUP(T4,Sheet2!$A$1:$B$10000,2,FALSE) the returning value is #N/A.

    Thank you for your help.

  6. Hi, I have been trying to figure this out for some time now so I hope you can help - I have 2 seperate spreadsheets that I need to combine into a sales forecast.

    Basically, I have 2 tabs in my sales and stock forecast -

    1st sheet has product SKUs in stock, and quantity
    2nd sheet has product SKUs and sales in units, not £

    I paste into the stock sheet from an external source, and also the sales from a different source - hence the seperation. The SKUs in stock may not always match the SKU sales, so I need to first match the SKUs, to save trolling through a large number of them, and then transfer over the sold units.

    eg:

    SKUs in stock
    tshirt 2
    bottle 4
    shorts 2
    cap 3

    SKU sales
    tshirt 1
    bottle 2
    cap 1

    So, I think, I need to match tshirt, bottle and cap in the forecast sheet and then match over the sales for each so I can then forecast the next stock.

    I hope this makes sense?!

    Many thanks in advance

  7. Dear all, I want data in below given foramt kindly help me

    Source Cell Neighour Cell Source Cell NB1 NB2 NB3 NB4
    A 1 A 1 2 3 4
    A 2 B 4 5 6 19
    A 3 C 7 8 9 10
    B 4
    B 5
    B 6
    C 7
    C 8
    C 9
    C 10

    Thanks

  8. I have 2 reports; one of previous report and one of current report.
    In the current report, I run vlookup against the previous report for dates to identify new entries and old entries. After which, I run true false to identify whether the dates of the previous report match/differs with the dates of the current report.
    The purpose is to check what are the new entries and also to check if there are date changes from the previous entries.
    The challenge is I create two columns, one for vlookup, one for true false.
    Is there anyway to combine both formulas and have just one column?

  9. Hi, seek help on below.

    Item1 1.05 A
    Item1 2.50 B
    Item1 7.85 C

    I need a formula to match both below:
    -item
    -price that could different by +/-0.50

    Example, if I lookup :
    a. Item1, 2.00 - Return B
    b. Item 1, 5.00 - Error

    Would really appreciate any help or just throw in any ideas as brainstorm. Thanks

  10. Team, i need code for below:

    Input:

    A 12
    A 11
    A 10
    B 11
    B 12

    Out put:
    A 12 11 10
    B 11 12

  11. Hi..super work and brilliant ideas. I have a problem in excel that I hope you may be able to help me with. I have a worksheet in which I want to find multiple values that correspond to a merge cell. My worksheet contains Buses 1-4 (A4:A11), each bus in 2 merged cells (for example Bus 1 in merged cells (A4:A5) and each bus has 2 routes (R1 & R2) and 3 stops (S1, S2, S3)in each route in the morning (AM), afternoon (PM), and night (HS). I want vlookup to find the times each bus in waits in each stop for each route at the three different periods (AM, PM, HS). Seems complex by I dried a hundred times to solve it..no way. Any suggestions? I can provide you with a screen snapshot of my excel sheet, or upload it if that helps. Thanks a million
    Samer

  12. Thanks
    info helped me a lot

  13. how many types of vlookup exist?

  14. Sl.No Inv. Ref. No. Inv.Rcvd. Date Status Month Vendor Code Vendor Name Invoice Date Job Ref. ID Inv. Amount 7 % GST Total Inv. Value Due Date Credit Days (terms)
    RE/PY/17 000017 8-Jan-13 PD 1-2013 0 EUROSAFE PTE LTD DECEMBER 3-Jan-15 R356 $36.90 $- $36.90 #N/A #N/A
    RE/PY/18 000018 24-Jan-13 PD 1-2013 0 VICTORIA PROPERTIES & INVESTMENT PTE LTD IN0000236125 23-Dec-14 R405 $2,519.23 $176.35 $2,695.58 #N/A #N/A
    RE/PY/19 000019 24-Jan-13 PD 1-2013 0 SP SERVICES LTD PSI-V9-77756 17-Dec-14 R405 $3,132.00 $219.24 $3,351.24 #N/A #N/A
    RE/PY/20 000020 24-Jan-13 PD 1-2013 0 SMS DESIGN PTE LTD PSI-V9-77755 20-Dec-14 R405 $1,350.65 $94.55 $1,445.20 #N/A #N/A
    RE/PY/21 000021 6-Feb-13 PD 2-2013 0 SWOT TECHNOLOGIES PVT. LTD. LSPI-001596 22-Dec-14 R405 $1,400.00 $98.00 $1,498.00 #N/A #N/A
    RE/PY/22 000022 7-Jun-13 PD 6-2013 0 EUROSAFE PTE LTD 4517 9-Dec-14 R400 $530.00 $37.10 $567.10 #N/A #N/A
    RE/PY/23 000023 20-Feb-13 PD 2-2013 0 SMS DESIGN PTE LTD INV-2014-074 22-Dec-14 R405 $10,330.00 $723.10 $11,053.10 #N/A #N/A
    RE/PY/24 000024 20-Feb-13 PD 2-2013 0 SMS DESIGN PTE LTD TU-IV1501-0119 1-Jan-15 R356 $3,480.00 $109.20 $3,589.20 #N/A #N/A
    RE/PY/25 000025 21-Feb-13 PD 2-2013 0 SMS CONSULTING ENGINEERS PROGRESS CLAIM NO.2 6-Nov-14 R400 $12,554.25 $878.80 $13,433.05 #N/A #N/A
    RE/PY/26 000026 25-Feb-13 PD 2-2013 0 VICTORIA PROPERTIES & INVESTMENT PTE LTD PT-2013-3512 20-Nov-13 R390 $350.00 $24.50 $374.50 #N/A #N/A
    RE/PY/27 000027 25-Feb-13 PD 2-2013 0 SP SERVICES LTD ADVANCE 7-Jan-15 R356 $25,000.00 $- $25,000.00 #N/A #N/A
    RE/PY/28 000028 12-Mar-13 PD 3-2013 0 EUROSAFE PTE LTD 11/348 24-May-11 R356 $1,000.00 $- $1,000.00 #N/A #N/A
    RE/PY/29 000029 12-Mar-13 PD 3-2013 0 SMS DESIGN PTE LTD 119618/2Q 31-Dec-14 R357 $50.00 $3.50 $53.50 #N/A #N/A
    RE/PY/30 000030 22-Mar-13 PD 3-2013 0 SP SERVICES LTD 76666 25-Jul-14 R357 $33.00 $- $33.00 #N/A #N/A
    RE/PY/31 000031 28-Mar-13 PD 3-2013 0 VICTORIA PROPERTIES & INVESTMENT PTE LTD PSI-V9-78007 27-Dec-14 R405 $1,147.50 $80.33 $1,227.83 #N/A #N/A
    RE/PY/32 000032 3-Apr-13 PD 4-2013 0 SP SERVICES LTD PSI-V9-78008 26-Dec-14 R405 $3,272.50 $229.08 $3,501.58 #N/A #N/A
    RE/PY/33 000033 3-Apr-13 PD 4-2013 0 SMS DESIGN PTE LTD 108020970 22-Dec-14 R405 $5,232.00 $366.24 $5,598.24 #N/A #N/A

  15. =VLOOKUP(G2,Table2[[Vendor Name]:[Vendor code2]],2,0) in need to some example this formulas i try to previous work based but i couldn't completed so kingly updated this

  16. Hello Svetlana, I want to create a formula that allows me to firstly find a matching code, then to find a matching date then once both of those items are found to populate the cell with the figure (this figure would be in the cell below the date) see below for example.

    Example 1 (I want to create the formula in the #REF cell under the 24,000):
    29820 Basket 31/03/2015 06/04/2015
    SOH 24,000
    Total OPENING SOH 24,000 #REF! #REF! #REF!
    Demand #REF! #N/A #N/A #N/A
    Projected Closing Stock #REF! #REF! #REF! #REF!

    Example 2 (this data is on a separate worksheet within the same spreadsheet):

    31/03/2015 1/04/2015 8/07/2014 19/08/2014
    29820 Basket 21760 27200 27200 21760 59840 27200 27200

    So ultimately I want to be able to firstly find the code 29820 in the worksheet, then if the date in the worksheet matches the same date in the main worksheet to populate that cell with the number below the date?

    Is this at all possible?

    Thanks,

  17. How to assign same value to a cell using dependent list?
    For(your)example: how can I assign/populate same list for two values(fruits) say 'Mango' and 'Apricot' dynamically without duplicating the list
    values?
    Please let me know.

  18. thank you for your detail explanation
    but i'm working with price table for the same product has more than one price ( from different supplier) i would like to be the output is the lowest price below

    pipe material pipe size pipe type pipe price pipe supplier
    pvc 100 sch40 62$ aapco
    pvc 150 sch40 72$ aapco
    pvc 200 sch40 82$ aapco
    pvc 100 sch40 55$ amis
    so i need the out if the pipe material is pvc and size is 100 and type is sch40 the lowest price (55)?
    can you help me please

  19. Svetlana,

    Thank you so much for this very helpful post. I'm trying to use the array formula for duplicate values in a range.

    =INDEX('Cert II Unit Selector'!$B$30:$B$39,SMALL(IF('Cert II Unit Selector'!K30:K39="Y",ROW('Cert II Unit Selector'!B30:B39)-1,""),ROW()-3))

    I keep getting a #Value error. Essentially, a "Y" is placed next to different selections out of many(say 16 out of 50), and i'd like the title of those labelled "Y" to be copied down row by row onto another worksheet.

    Your formula seems to be the best option for this (I'm VBA shy) but I can't get it to work? Am I doing something wrong?

  20. Hi Svetlana,
    Your tutorials and instructions are fantastic! I am under the impression that the function/formula I am trying to create is not possible in Excel and I am at my wits end. Here is the basic gist:

    Column A contains various vendors
    Column B contains various account types

    I would like to have it so that each cell in an entire sheet will provide the results of each criteria (all of the data is text)

    Column A header is ingredient 1
    Column B header is add 2

    Column A2: Eggs
    Column B2: Bacon
    therefore.....
    Column C2: Delicious

    Column A3: Yogurt
    Column B3: Cheese
    therefore.....
    Column C3: Gross

    Column A4: Banana
    Column B4: Peanut Butter
    therefore.....
    Column C4: Healthy

    I am happy to send over a sample spreadsheet I have that I've been playing with. The report I use typically has 200-300 rows of data. Currently this analysis is done manually and takes DAYS. Thank you!

  21. Saved me hours of formula testing and frustration.
    5 mins of reading saved hours of vlookup frustrations.

    Thank you very much

  22. this is relay very help full for me thank your dear Svetlana Cheusheva.

  23. i have a worksheet with various data, i want to transfer some selected columns and multiple rows at the same time in other worksheet using vba

  24. Hi,

    I have a data of staff name, date and daily productivity.

    Data catagory as "Actuals"
    A B C D E
    Date Name Productivity % Agent Occupancy AHT
    05-Jan-15 Staff A 107 51.42 129
    06-Jan-15 Staff A 77 49.58 167
    07-Jan-15 Staff A 100 62.69 162
    05-Jan-15 Staff B 68 61.99 198
    06-Jan-15 Staff B 50 64.38 321
    07-Jan-15 Staff B 67 74.51 255
    05-Jan-15 Staff C 32 73.20 192
    06-Jan-15 Staff C 20 59.11 194
    07-Jan-15 Staff C 66 57.87 176

    How can i lookup for Staff A, C=B & C Performance as below?

    05-Jan-15 06-Jan-15 07-Jan-15

    Productivity
    Staff A =VLOOKUP("Staff A",Actuals,MATCH(05-Jan-15,Actuals,0),FALSE)
    Staff B
    Staff C

    % Agent Occupancy
    Staff A
    Staff B
    Staff C

    AHT
    Staff A
    Staff B
    Staff C

    The formula seem doesn't work. May you assist?

    Thanks,
    Jenny

    1. Instead of using lookup formula you can use Sumproduct function...

      As per your info suppose you want to see the performance of Staff A for 5th Jan 2015...

      So as per your column format the formula would be

      Productivity

      =SUMPRODUCT(--(TEXT($A$2:$A$11,"d-mmm-yy")="5-Jan-15")*($B$2:$B$11="Staff A")*($C$2:$C$11))

      % Agent Occupancy

      =SUMPRODUCT(--(TEXT($A$2:$A$11,"d-mmm-yy")="5-Jan-15")*($B$2:$B$11="Staff A")*($D$2:$D$11))

      AHT

      =SUMPRODUCT(--(TEXT($A$2:$A$11,"d-mmm-yy")="5-Jan-15")*($B$2:$B$11="Staff A")*($E$2:$E$11))

      Please check...

  25. Hi,

    I have a series of data.

    Category No. EBT 53,483
    1 Computed expected tax 18,719
    2 State taxes, net of federal effect 469
    3 "Indefinitely invested earnings of
    foreign subsidiaries" -4,744
    4 Research and development credit, net -88
    11 Domestic production activities deduction -495
    11 Other 112
    Provision for income taxes 13,973

    I need vlookup to find the categories 11, add both the ocrresponsing numbers (i.e. -495 and 112) and present it in the cell.

    Can i do this. I tried =SUM(VLOOKUP(lookup value, lookup range, {2,3}, FALSE)) but it doesnt work as the numbers are 1 blow the other.

    Its urgent... can some1 plz help.

    Thx

    1. you can use the sumproduct formula...Suppose Column A contains Category number and columns B contains the corresponding number ...so to find the added value for category 11 you can use the below one...

      =Sumproduct((A2:A12=11)*(B2:B12))

      Please check and confirm...

  26. imagine there are several numbers from 1 to N, and each number can be repeated n times. each number has a specific price. by entering a number from 1 to N How is it possible to get the lowest price from the data table. for example :

    Numbers Price
    1 300
    3 400
    7 700
    8 650
    6 300
    5 200
    1 150
    3 400
    7 210
    7 340

    Now by entering 7 we want to find the lowest price which is 210.
    how is it possible?? please help me . thank you in advance.

    1. Hi Alireza..

      If you can sort the data by ascending order then I guess it would be possible by below method..

      Suppose You have column from B2 to B11 the number from 1 to N and its corresponding column (C) contains the specific prices..Then sort the data from largest to smallest at column C then by Column B..After that use the below array formula ..

      =(INDEX($C$2:$C$11,SMALL(IF(7=$B$2:$B$11,ROW($C$2:$C$11)-1,""),1)))

      Please do not forget to press Cntl+Shift+enter after putting the formula..

      Please let me know if it is working or not... In the mean time I will be looking for another method...

      1. Thank you so much for your swift answer. I will try it and I will let you know.

  27. HI Svetlana, i know..that its discussed here, but still i neeed some vlookup which would choose according to 2 criteria in one line /third value from another sheet/ and from this sheet will be filled into first sheet - /where are 2 criterias/
    is any possible to send it the excel? that i could explain better. Thank you

  28. Hi Svetlana, Thanks a ton for this article..

  29. You've just nailed it Svetlana, love you! Many thanks for this Excel cheat lol

  30. Help Full

  31. Hello Svetlana;

    How I can adjust age brackets with vlookup formula using multiple criterias.

    Plan Gender Age Contribution
    Plan A Male 0-17 1,703
    Plan A Female 0-17 1,703
    Plan B Male 0-17 1,569
    Plan B Female 0-17 1,569
    Plan C Male 0-17 1,426
    Plan C Female 0-17 1,426
    Plan A Male 18-30 1,260
    Plan A Female 18-30 1,264
    Plan B Male 18-30 979
    Plan B Female 18-30 979
    Plan C Male 18-30 2,597
    Plan C Female 18-30 3,866

    I have the date in above mentioned form and I want contribution data on an other sheet using vlookup with other 3 criterias for exact match on other sheet.

  32. Hi Svetlana
    When doing the formula =IFERROR(VLOOKUP($F$2,INDIRECT("$F$2,$B$2:$B$16,0)+2)&":$C16"),2,FALSE),"")to identify the 2nd occurrence for each name with the appropriate product, my formula returns a 0 every time I change the name. This is despite copying the one from the download sample and changing any cell references to match above. Would have any ideas as to why this happens?. Thank you.

  33. how to use H lookup and V lookup for archiving data any suitable example?

  34. Thank you for this interesting post. I could not find what I was looking for however.

    I need to find values in rows with multiples criteria.
    In the example below I have the same material being ordered under several PO numbers.

    I need a formula that will tell me how many pieces of material #2 have been ordered under PO #2

    Data table
    Material# PO# OnOrder

    material1 PO1 5
    material2 PO1 10
    material3 PO1 15
    material2 PO2 10
    material3 PO2 8
    material4 PO2 12

    Result table

    PO2 (citeria 1)
    material2 (criteria 2) result = 10

    Thanks

  35. Hi, I'm doing my best to understand vlookups. I wanted to know if you can further break down the following formula that you had posted. I want to fully understand why it works. The formula is from the tutorial about looking up duplicates with vlookup. Thank you:

    {=INDEX($C$2:$C$16,SMALL(IF($F$2=B2:B16,ROW(C2:C16)-1,""),ROW()-3))}

  36. Hello,

    I'm trying to add multiple VLOOKUP's together (week 1, 2, 3, etc), which I can do. But if one week is missing the item I'm looking up (person didn't take calls that week), it's giving me a "FALSE". I tried to use the ISERROR, but it keeps giving me a "0". I know why it gives the zero, but I'm not sure how to make it "skip" that week if the person isn't found.

    Example:
    IF(ISERROR((VLOOKUP(B2,'Team Stats Week 1'!B2:P21,2,FALSE))+(VLOOKUP(B2,'Team Stats Week 2'!B2:P21,2,FALSE))),0,(VLOOKUP(B2,'Team Stats Week 1'!B2:P21,2,FALSE))+(VLOOKUP(B2,'Team Stats Week 2'!B2:P21,2,FALSE)))

  37. I am using google forms to make sure that staff read the circulars.
    They fill up the form once they have read it.
    The responses are automatically shown in a spreadsheet.

    So, I have staff name in column B and Circular name in Column C
    I want 0 to be shown in a column if a staff has read all 4 circulars.
    How do I make that work?
    Any help is greatly appreciated.

  38. Hi Svetlana,
    I want to fetch all items in comma separated in Sheet1, col(n) from Sheet 2 col(x) which look value is in col(x-2).

    Please let me know how can i do this.
    Thanks in advance.

  39. Hi Svetlana,

    Thank you so much! Your explanation was perfect. I understand now how the formula works and was able to successfully complete my project. Thank you very much for the quick response!

    -Will

  40. Hi Svetlana,

    This is one of the best technical Excel posts I have ever had the pleasure to read. Thank you and well done! I do have a question however, what precisely are the "Row" functions doing in the array formula? I am having a hard time unpacking what is going on there... I understand the syntax but not the context. Would you please break that down a little bit more?

    Lastly, in your example: "How to get all duplicate values in the lookup range", how would you re-write the formula to report the purchased products next to the customer name, starting in cell G2 and continuing on to the right to cell J2, etc?

    Thank you for your help!

    -Will

    1. Hi Will,

      Thank you for your kind words and a great question : )

      I thought other readers might want to know the details too, so I've added the formula explanation to the post, hopefully it will be helpful.

      And here's the formula "to report the purchased products next to the customer name, starting in cell G2 and continuing on to the right to cell J2":

      =IFERROR(INDEX($C$2:$C$16, SMALL(IF($F$2=$B$2:$B$16, ROW($C$2:$C$16)-1,""), COLUMN()-6)),"")

  41. i want to compare two spredsheet with name and amount in one sheet is contain in another sheet in same combination . wich formula i use

  42. i want sheet to sheet multiply total formula .. excell sheet

    1. Hi Prem,

      It is difficult to recommend anything based on such generic description. Most likely you need to use the SUMPRODUCT function.

  43. This is great! Thank you

  44. CAN WE GET MORE THAN ONE COLOUMN OF DATA SIMULTANEOUSLY BY VLOOKUP...???

  45. Hi, I have a workbook with multiple tabs. In my master sheet I have values in column A (AA, BB, CC, DD, EE....for example). Then I have tabs labeled AA, BB, CC, DD, EE. I'm trying to do the same vlookup but on different tabs depending on what my master sheet column A value has...

    So if Column A is BB I want the vlookup to look at sheet BB. Here is the manual way of doing it:

    =VLOOKUP(B1,BB!A:B,2,FALSE)

    Here is what i want the formula mimic so it works in a similar fashion:

    =VLOOKUP(B2,A2&"!A:B",2,FALSE)

    I also tried giving A:B on sheet BB a reference of 'BB' in hopes this would work:

    =VLOOKUP(B2,A2,2,FALSE)

    Any help is appreciated!!!

    1. I need to do the same sort of thing as Luke.

      I Have a cell lets say its A1 that specifies from a drop-down list a Sheet Name (AA BB CC DD etc)
      I want to pass that reference to a VLOOKUP Formula which would be SOMETHING LIKE =VLOOKUP(B5,A1&!D1:E22,2,False)
      Where B5 is the cell containing theLookup_value, A1 is the cell containg the sheet name, and D1:E22 is the Table array.

      I have been told the INDIRECT formula should work but I am jet to find a way to get a successful result.

      Anyone Know?

  46. I have the following
    A 2
    B 5
    C 3

    I want it to
    A
    A
    B
    B
    B
    B
    B
    C
    C
    C

    Can you help me with excel formula

    1. Hello Daro,

      A special VBA script will be the best solution to your task. Sorry, I cannot help with this.

  47. I need a formula were in can get what ever the data i feed in from sheet 1 to sheet 2 in the same workbook ?

    1. Hello Samantha,

      If you need to simply have the data copied from sheet1 to sheet2 as you enter it, you can put this formula in cell A1 on sheet2 and then copy it to all other cells:
      =Sheet1!A1

  48. Dear Sir,

    Iam trying to do lookup with multiple cateria like

    I have one sheet with account number,name & business

    as well I have one sheet, when I will mentioned account number in sheet one formula will check aacount number & name then business will come

    1. Hello Sandeep,

      A similar example is described in How to do a vlookup with multiple criteria. This example explains how to look up with 2 criteria "Customer Name" and "Product". Your can download the example in the end of that section and adjust the cell references in the formulas.

  49. Dear Svetlana,

    I am very much impressed by the guidelines you are providing for the problems faced by the Excel users. Really it is a quite best Website for having expert advice for advanced Excel users.

    Thanks for your sharing.

    With regards.

    CMA Anand

    1. Thank you very much for your kind words, Anand! I'm pleased to know you've found the tutorial helpful.

  50. Dear Svetlana,

    thank you for such a great site. I'm actually learning to use excel as more than just a list keeper. As I was using your formula for duplicate values in a look up range, I ran into a few problems. The information was only being picked up in one cell (I'm searching for dates). After I set the dates in the original column and the lookup column to the exact format, all of the dates show except for the first dates on the original list. I'm sure it's a small tweaky thing but I've been at it for 3 hours with no success. Do you have any suggestions on what I should look for as I'm troubleshooting? Thank you.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)