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 4. Total comments: 540

  1. I'm trying to use xlookup with multiple criteria across several columns and ~15000 rows of data. The xlookup function returns a value for each row, but the data matches the return array row and not the criteria across columns. For example, data in row 100 in both my table and the return array (source) file is the same, even though the criteria is from row 90 (I don't need all 15,000 rows of data). Do you know why the formula is picking up the data in the row and not from the criteria related to the row?

  2. In a MASTER sheet, I'm having SKU, fulfillment center, and Quantity. need to fetch quantity according to the matching of SKU and fulfillment center in another sheet. because the data of the master sheet will change every time.

    1. Hi!
      You can learn more about VLOOKUP with multiple criteria in this article above. If this is not what you wanted, please describe the problem in more detail.

  3. Hello,
    I am trying to put some data from baseball box scores into an Excel sheet. What I am trying to do specifically is bring in the pitchers for each team into a section of the sheet and then populate another area if a pitcher gets a certain stat (Win, Loss, Hold, Blown Save and Save).
    Each game will have a pitcher get a Win or a Loss but the other three stats may or may not happen each game. The pitcher will be listed with a First Name and Last Name unless they get the certain stat and then the stat will be there along with either how many of the stat or their win-loss record. (Examples: John Smith or John Smith, W (4-3) or John Smith, L (3-4) or John Smith, H (17) or John Smith, BS (3) or John Smith, S (10))

    Here is an example:
    I put the stats in column A1:A5 (W L H BS S) as the lookup value for the stats.
    The pitchers will be copied in column C - Visiting Pitchers in C1:C8 and Home Pitchers in C10:C17. These cells may not all be filled in each game.
    What I want to do is look in both columns and find the stat looked up in column A and put the pitcher's name, stat and/or record from the examples I gave above in the cell that applies to the stat. So I want John Smith W (4-3) from the list to go in cell D1 for example for the winning pitcher. The cell for Win and Loss will each only have one result as well as Save. Hold and Blown Save can have more than one result and I can lost those in multiple cells.

    I hope I have explained this well enough and I can provide more clarity if necessary.

    Thanks for any help you can provide.

    1. Hi!
      This is a complex solution that cannot be found with a single formula. If you have a specific question about the operation of a function or formula, I will try to answer it.

  4. Scenario:

    Sheet 1 is having Names in Column 1 and Row1 is having the Dates.
    Sheet 2 is having Names in Column 1 and Row1 is having Dates.

    I need the formula to return the Dynamic index (Cell).

    Ex: Sheet 1 If the Name and Date match with the Sheet 2 Name and date - Return the particular column values.

    1. Hi!
      Pay attention to the following paragraph of the article above – How to Vlookup in rows and columns (two-way lookup).
      It covers your case completely.

  5. Please help!! Been using Vlookup for a year already the same data over and over and got no N/A nor errors, but this fast weeks we've been experiencing NA. Absolutely sure that formula is correct, lookup_value and table_array references were made absolute correct. Still looking for what may have caused the N/A then correct data, the N/A again cycle goes on like this below: Thank you
    #N/A
    #N/A
    MARIES
    Karmelyn
    Liza
    Ely
    Lara
    #N/A
    #N/A
    #N/A
    #N/A

  6. HI!

    I am struggling with a VLOOKUP and Im not sure why

    I have a column of 18 fields C2:C18

    Coulmn A is filled with roughly 3000+ fields, some of which match what is in the range C2:C18

    Column B is filled with account numbers

    How do I lookup the C2:C18 in column A and return the account number from column B that has a match?

      1. Hey!

        I am looking to see if any of those 18 values from column C match anything in Column A and if they do to return the account number from Column B.

        There might be multiple matches in Column C but a different account number that matches from B

        That formula would only check column A for 1 of the 18 from Column C?

        1. Hi!
          I don't want to guess what you're looking for. Give an example of the source data and the expected result.

          1. Charge (A) Acc number (B) Charge to look for (C)
            XXX1234 Acc 1 CCC1234
            AAA1234 Acc 2 PPP1234
            BBB1234 Acc 3 SSS1234
            CCC1234 Acc 4 EEE1234
            DDD1234 Acc 5
            EEE1234 Acc 6
            FFF1234
            GGG1234
            HHH1234
            III1234

            So I am looking to search the entire of Column A for any result that matches the entire of Column C and return the account number from Column B that the charge is on. I hope that makes more sense, apologies!

            1. =VLOOKUP(C2:C18,$A$2:$B$3111,2,0)

              This is what I came up with but I'm getting an #N/A result for entire sheet, when i know that there are matches. Is there a limitation with VLOOKUPS when searching for multiple criteria in a table?

              1. Hi!
                Note that the VLOOKUP function can only look up one value. You want to search multiple values at once. To not display an error message, use the IFERROR & VLOOKUP function. Please read the VLOOKUP manual carefully.

                =IFERROR(VLOOKUP(C2,$A$2:$B$3111,2,0),"")

  7. Hello,
    I am trying to write a formula that looks at three criteria and if all three criteria are met return a name.

    I have the names in cells b17 through b36.

    The first match I need is in cells e17 through e36. In these cells the number can be <= 2
    The second criteria is in cells f17 through f36. In these cells the numbers can be 9.
    If all three of these criteria falls within the range given, I need the result to be the name listed in cells b17 through b36

    I have followed the match index but it’s not working for me.

    If you can let me know if this can be done I am great full.

    Thanking you in advance, Chuck Vaughan

    1. Hi!
      Please clarify your question. Should the condition be true for all cells in the range or just one of them? Is the result of the formula also a range of cells?

  8. Great source of how to use Lookup functions.
    Is there any way to make the lookup_array dynamic or a computed value (without using named ranges that are defined)? I've tried using the indirect function as you have but in the form of
    =VLOOKUP(lookup_value,INDIRECT(B2)&":"&INDIRECT(D2), columnIndex, rangeLookup)
    where B2 and D2 are the corner points of the desired array (in the form of $f$10 and $p$100)
    array 1 $f$10:$p$100
    array 2 $q$10:$aa$100
    array 3 $ab$10:$al$100
    etc...
    Using defined named ranges creates additional workload and using a fixed lookup_array creates a massive array.

    1. sorry, I was using the Indirect function incorrectly, but using the equation
      =VLOOKUP(lookup_value, B2&":"&D2, columnIndex, rangeLookup)
      just gives me a '#value' error because apparently B2&":"&D2 is evaluated as the string "$f$10:$p$100" and not the range $f$10:$p$100.

      1. my apologies again, after some additional trial and error the following works - but thanks for your tutorial it definitely helped in solving my problem.
        =VLOOKUP(lookup_value, INDIRECT(B2&":"&D2), columnIndex, rangeLookup)

  9. Name/date 7/22 7/23 7/24
    name1 65 55 22
    name2 0 22 19
    name3 2 59 0

    Hi pls refer to the table I want to know when I select date I want to get cell values 1st highest to low then i need to get corresponded row value in front of that number

    Say I Select 7/24

    the result should be:
    22 name1
    19 name2

    1. Hi!
      The following tutorial should help: Excel INDEX MATCH MATCH and other formulas for two-way lookup.
      Please try the following formulas:

      =LARGE(INDEX(B2:E4,, MATCH(H2,B1:E1,0)),1)

      =INDEX(A2:A4,MATCH(LARGE(INDEX(B2:E4,, MATCH(H2,B1:E1,0)),1), INDEX(B2:E4,, MATCH(H2,B1:E1,0)),0))

      where H2 = "7/24"
      The LARGE function with an argument of 1 specifies the highest value in the range. For the second value, change 1 to 2.
      I hope it’ll be helpful.

  10. 2 sheets with addresses, trips sheet and jobs sheet. Trips is from fleet software tracking address of vehicle. Jobs sheet is job address and job data including job#. I need a column on trips sheet that looks to the job sheet addresses, finds the clise match and returns the job #.

    Have tried vlookup and indexmatch.

  11. Does the author issue any Email Seminars or thoughts? She is truly one of a kind - great Excel Seminars and would truly appreciate being advised of any & all seminars she might offer.

    Thoughts?

    Being researching Excel seminars for the last few decades & have found she is the leader - best

    1. Thank you for your kind words, Waldo. I do not run any email seminars. You can find all my Excel articles on this blog.

  12. I have inventory spreadsheet from month to month. The ending inventory of the previous month is the beginning inventory for the current month. Sample Formula for the current month =IF(ISNA(VLOOKUP(V2,Mar22!C:D,2,FALSE)<=0),0,(VLOOKUP(V2,Mar22!C:D,2,FALSE))). The formula works, however, I want the negative balance to show as "0" for the following month. Please help. Thank you

    1. Hello!
      Add one more condition to the formula with a nested IF function. I can't check the formula that contains unique references to your workbook worksheets.

      =IF(ISNA(VLOOKUP(V2,'Mar22'!C:D,2,FALSE)),0, IF(VLOOKUP(V2,'Mar22'!C:D,2,FALSE)>0, VLOOKUP(V2,'Mar22'!C:D,2,FALSE),0))

  13. Hello,

    I am attempting to retrieve certain data using a unique identifier (123456), points from another sheet onto the main one I need the data on though there are multiple data points.
    This the formula I am using but keep getting an error:
    =VLOOKUP(A2,INDIRECT("A"&(MATCH(A2,Gradebook!$A$2:$F$2891,0)*ROW(Gradebook!A1:A2891))&":M2891"),6,FALSE)

    One tab in the workbook is titled Main and these are the data points (below):
    Student ID First Name Last Name Grade P1 Course P1 Mark P2 Course P2 Mark P3 Course
    123456 Student Test 9
    Which I am trying to pull the data points from tab titled, Gradebook, that contains the data points below
    Student ID Student Name Course Periods Mark Perc
    123456 Test, Student Literature 12 P1 C 72.33
    123456 Test, Student Chemistry P2 F 57.28
    123456 Test, Student Geometry P3 D 60.53
    123456 Test, Student Theater P4 B- 80.25
    123456 Test, Student Ethnic Studies P5 B- 80.35
    123456 Test, Student Fitness P6 C+ 78.92
    Which formula I can use, how can I pull the data points from Gradebook to paste onto the Main tab under each column?

    Thank you!

      1. =INDEX(Gradebook!$G$2:$G$2891,SMALL(IF($A2=Gradebook!$A$2:$M$2891,ROW(Gradebook!$A$2:$M$2891)-1,""),1))

        I found this formula and it pulls the data I need but it is possible for it to pull data from a column based on data from another column?

        For example:
        Student ID 123456 has 3 columns of data
        Column A: PE
        Column B: Period 1
        Column C: A+
        How can I pull from any data point from Column A when column B contains specific text such Period 1, Period 2, etc?

  14. I been working to recreate this seminar and have a few questions:
    1)How to Vlookup and return multiple values in Excel - utilize INDEX, SMALL & ROW functions section Formula - {=IFERROR(INDEX($C$2:$C$11, SMALL(IF($F$1=$B$2:$B$11, ROW($C$2:$C$11)-1,""), ROW()-1)),"")}

    If the cell containing this formula is C250 how does the above change? Should the "ROW()-1" become "ROW()-250? Can't get this to work

    2)Name Range "Product" in one of your sections you state the range for Product as B2 It should shown as B2:B11

    Thoughts?

    Your seminars are one of the best if not THE BEST - many thanks Outstanding & very educational

    1. Hi Waldo,

      1) The generic formula is this:

      IFERROR(INDEX(return_range, SMALL(IF(lookup_value = lookup_range, ROW(return_range ) - m ,""), ROW() - n )),"")

      Where:

      - m is the row number of the first cell in the return range minus 1.
      - n is the row number of the first formula cell minus 1.

      Assuming both the first cell in the return range and the first cell containing the formula are in row 250, you formula may look something like this:

      =IFERROR(INDEX($B$250:$B$260, SMALL(IF(D$249=$A$250:$A$260, ROW($B$250:$B$260)-249,""), ROW()-249)),"")

      For the detailed explanation, please see How to Vlookup multiple matches and return results in a column.

      2) Can you please specify the section's name? Cannot find it.

    2. Your Section - How to do multiple Vlookup in Excel (nested Vlookup) - 2 subanalysis to VLOOKUP 3rd file

      Shows the "Products" range as D3:E3 believe it should be D3:E10
      Shows the "Prices" range as G3:H3 believe this should be G3:H10

      Thoughts?
      Thanks

      1. You are absolutely right, fixed. Thank you for pointing out that mistake!

  15. I am trying to use this =VLOOKUP($A4,Data2!$A:$AC,H$1,FALSE) to pull forecast for multiple months from data file but this does seems to be working, could you please walk me through to use this formula appropriately ?

  16. I'm looking for a solution to work around using vlookup + vlookup
    The data set is something like this:
    10
    20
    31;32
    40
    The current idea is to insert enough columns to separate all items, then iferror(vlookup,,,),0) + iferror(vlookup,,,),0) + iferror(vlookup,,,),0) to sum all instances, or manually overwrite the single vlookup on the lines where multiple items are needed

    1. Hello!
      Sorry, I do not fully understand the task. Could you please describe it in more detail? What result do you want to get?

  17. Hi. Can you please tell me what exactly do the following formulas yield. PLEASE!

    =VLOOKUP(C2,M2:N180,2,0)

    =VLOOKUP(C9,M:M,TRUE,FALSE)

  18. Hi There

    i worked in logitics company where i need to to find Vlookup 1,2 and 3 occurence value that are in same column against in a order and want answer in column 1, 2 and 3 and then if blank choose other option kindly help me , to fix this

  19. I have an excel data like following, i want to Securitate only work completed line items in another work sheet, which formula we can use in VLOOKUP

    SL.NO. QTN STATUS QTN REFE NO.

    2 PENDING CS-QTN-06-21-0002
    3 WORK COMPLETED CS-QTN-06-21-0003
    4 REJECTED CS-QTN-06-21-0004
    5 WORK COMPLETED CS-QTN-06-21-0006
    6 WORK COMPLETED CS-QTN-06-21-0007
    10 PENDING CS-QTN-06-21-0013
    11 WORK COMPLETED CS-QTN-07-21-0005
    17 PENDING CS-QTN-07-21-0017
    18 PENDING CS-QTN-07-21-0018

  20. HI Team
    im using the below formula from vlookup-in first cell i entered fileExcel -3201
    and i need to change each cell for example-3201,3202,3203.how to do it

    find below for clarify

    =VLOOKUP($B64,'C:\Users\Desktop\Excel 3201\[TOP BOTTOM KEY_16.12.2021_3801.xls]Report'!$A$14:$B$20,2,0)

    1. Hello!
      Here's how to get a link using the formula:

      =INDIRECT("'"&B2&"["&A2&"]"&C2&"'!$A$14:$B$20")

      A2 - file name (TOP BOTTOM KEY_16.12.2021_3801.xls)
      B2 - File folder name (C:\Users\Desktop\Excel 3201\)
      C2 - sheet name (Report)

      In order for the link to work, the file must be opened, otherwise, you must use a VBA macro.
      You can read more about using the INDIRECT function in an article on our blog.

  21. Hi Svetlana,

    I am new in Excel and I would like to use codes.
    I would like to assign A=1, B=2, C=3, D=4, E=5, F=6, G=7, H=8, I=9, J=0.
    if I would enter DJ, the value would be 40
    If I would enter FCB, the value would be 632
    Your help is appreciated.

    1. Hi!
      To change a letter to the corresponding digit, you can use the SUBSTITUTE function.

      =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"C","3"),"B","2"),"A","1")

      You can continue this formula with other letters and numbers.

  22. Hi I'm try to make a vlookup with this information .
    Category Indicates the category the item belongs to. Item categories are: “Bread & Bun”, “Cookie”, “Cake” and “Pastry”. Each ItemID beginning with the letter B belongs to the Bread & Bun category; those starting with K belongs to the Cookie category; those starting with C belongs to the Cake category; and those starting with Y belongs to the Pastry category.

  23. Is there a way to perform a VLOOKUP and have it be case sensitive? For example, our ID's are 11384fMY15KIv and there may be one that is 11384FMY15KLv. Each one is different but the VLOOKUP function will return just one.

  24. Hi, I am curious to know what will be the formula be if we are looking for 3rd occurrence instead of 2nd occurrence?

    Understand that from the formula shown above, +2 = +1 to exclude the first instance and +1 to exclude row 1 with the column headers

    =VLOOKUP(E1, INDIRECT("A"&(MATCH(E1, A2:A11, 0)+2)&":B11"), 2, FALSE)

    If the 3rd occurrence is 5 - 6 rows below 2nd occurrence, what will be the formula?

    1. Hello!
      This formula finds the third match in the VLOOKUP search:

      =VLOOKUP(E1,INDIRECT("A"&(MATCH(E1, A2:A11, 0)+1 + MATCH(E1, INDIRECT("A"&(MATCH(E1, A2:A11, 0) +1+ROW(A1))&":A11"), 0)+ROW(A1))&":B11"), 2, FALSE)

      1. hi this work in practise sheet and but able to help in real time solution

  25. I wanted do vlookup in the main file from the different excel files. I need information in the one column in main file. I.e if booking pertains to CC then only CC files needs to be referred in Vlookup and similarly if booking pertains to other type then respective file should be referred for vlookup.

  26. Hello,
    I used the vlookup and it works but now i cant move the column to another excel. returns #REF!
    please HELP ME!!

  27. I have been trying to use a vlookup in my spread sheet, but i cannot seem to get it to work correctly. Maybe i need something else?
    Data columns on my data sheet are:
    (A)Truck #, (B) Date, (C) Miles Driven and (D) Driver Name

    What I need to do is:
    look up the truck # by date and return the driver name

    Any and add suggestions are greatly appreciated.

  28. 0

    I don't know if this is even possible I am going to try to explain it the best I can, I don't know if the "IF" function is the correct thing to use here...

    I want to Vlookup From a list in Column A but what I want to look up is dependent on what is in Column B

    I don't know how to put this in a formula or even if you can:

    If B3=R then =VLOOKUP(C3,Sheet1!$B:$R,11,false) If B2=L then =VLOOKUP(C3,Sheet2!$B:$R,11,false)

    Is this possible? Any suggestions how to approach it, is there a better function that I don't know of yet? Thank you

      1. THANK YOU! This worked! I was on the right track, saved me a few more hours of trial and error

  29. Hey can u plz tell... is there any shortcut to go to the cells on which our vlookup function is dependent if those cells are in a different sheet.

  30. Hello,

    Im trying to find a vlookup that will return when a value is found in the column (when there is no blank). For example:

    item
    item
    item value1

    VLOOKUP should return "value1", not 0 or blank. How can I accomplish? Thank you.

    1. Hello!
      VLOOKUP function will not be able to solve your problem. Use INDEX + MATCH in formula:

      =INDEX(B2:B20,MATCH(TRUE,(A2:A20="item")*(B2:B20 > 0) > 0,0))

      You can learn more about INDEX + MATCH in Excel in this article on our blog.

      1. Unfortunately this only returns me #N/A. Is there another way?

        1. Found the issue. It needs to be shift + ctrl + entered :)

  31. Dear Mam

    =IF(C8<711,5.12,) this is being charged as working days
    Do you an idea that 6.14 will be charged on weekend days instead of 5.12 in the same formula.

    Thanks

  32. Is there any way to allocate product based on available production to meet model wise item target with minimum and maximum quantity per day? thanks in advance.

  33. I have 2 excel sheets, both containing EAN of products. 1st sheet has 9000 EANs while 2nd sheet has 7000 EANs. 1st sheet have same 7000 EANs same as in 2nd sheet but remaining 2000 are not common in both sheet. Please let me know how can I find which 2000 EANs are not in 2nd sheet using Vlookup command.

  34. SKU _XS _S _M _L _XL _2X _3XL Total
    Os103 10 10 10 10 10 10 10 70

    I have a data in this way but i want to convert this excel data this format

    SKU Qty
    Os103_XS 10
    Os103_S 10
    Os103_M 10
    Os103_L 10
    Os103_XL 10
    Os103_2XL 10
    Os103_3XL 10
    I have try to some formula in Excel Like Vlookup and &&
    Any one can help ??

  35. I am trying to complete a project for work to calculate BMI and I'm not sure how I should go about it. This is what I've accomplished thus far:
    CELL
    C2 = height (inches, I used mine which is 77)
    C3 = weight (lbs, I used mine which is 210)
    C4 = BMI (=703*$C$3/$C$2^2) this returns a 24.90 rounded up slightly with .00 formatting
    C5 = BMI Status

    C5 is where I am experiencing difficulties. I have a separate table for a BMI chart in the same sheet which encompasses H2:J6. H2:J2 Row are my column headers for the table (BMI Low Range, BMI High Range, BMI Status). Below is my chart data:
    Cell
    H3 = 0 (BMI Low Range)
    I3 = <18.5 (BMI High Range)
    J3 = Underweight

    H4 = 18.5 (BMI Low Range)
    I4 = <25 (BMI High Range)
    J4 = Normal

    H5 = 25 (BMI Low Range)
    I5 = <30 (BMI High Range)
    J5 = Overweight

    H6 = 30 (BMI Low Range)
    I6 = 200 (BMI High Range)
    J6 = Obese

    What I'm trying to accomplish is taking the calculated result from C4 and comparing it to the BMI chart. The corresponding BMI status in the chart (ie J3:J6) will display in C5.
    =IF(COUNTIF($C$4,H3&"<"&I3),J3)& IF(COUNTIF($C$4,H4&"<"&I4),J4)& IF(COUNTIF($C$4,H5&"="&H6),J6)

    All it returns is FALSEFALSEFALSEFALSE... with the 24.90 calculated result I have in C5 now it should return at a minimum FALSETRUEFALSEFALSE or FALSENORMALFALSEFALSE right? I'm thinking that vlookup may be what I need but am unsure.

    Any help would be greatly appreciated and thank you for your time.

    V/r,
    James

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =VLOOKUP(C4,H3:J6,3,1)

      I hope this will help, otherwise please do not hesitate to contact me anytime.

  36. Hello, please make a correction:
    Formula 2.
    =INDEX(D2:D11, MATCH(1, (G1=A2:A11) * (G2=B2:B11) * (G3=C2:C11), 0))
    Needs to be entered as array formula with Ctrl+Shift+Enter

    {=INDEX(D2:D11, MATCH(1, (G1=A2:A11) * (G2=B2:B11) * (G3=C2:C11), 0))}

    Thx! Nice article!

    1. Hi Alexandr,

      Thank you for pointing that out! In Excel 365 that I am using it works as a regular formula due to support for dynamic arrays, and I completely forgot about older versions, sorry for that. I've added a note about Ctrl + Shift + Enter. Thank you!

  37. Use your mouse to enter an IF function that displays a value of “Yes” if the Stock Qty field (cell F5) is less than or equal to the Reorder Qty field (cell H5) and “No” if it is not.

  38. Hi,

    Do you know how can I use the lookup value of 2000 parameters?

    Thanks,
    Mariecris

  39. i have same reference number- under muliple data's, i should take vlookup in other excel. how to take?pls help

  40. How to find same names same code persons are duplicate
    Ex:-
    1. Naresh 000
    2. ABC 212
    3. naresh 000
    4. ABC 212

  41. Hello,
    I want to run a daily manning report from an excel roster but don't know how to go about it. I want it to be set up as classifications and Manning Numbers and then have total of each classifications and so it has to provide having personnel showing as on isolations from the current manning as well.
    Can you help me?

  42. i have C collumn Col-A,Col-B & Col-C
    Under Col-A 4 Data(A1=Name,A2=Ram,A3=Ram,A4=Ram)
    Under Col-A 4 Data(B1=Salary,B2=Blank,B3=Blank,B4=4000)
    Under Col-A 4 Data(C1=Attendance,C2=Blank,C3=P,C4=A)
    Suggest me formula by Vlookup & Index where i can get the data from Col B(Salary) & Col C(Attendance).after Blank.Name is same in A col when run the formula based on Name then form the array provide me 4000 from B col and P from C col. its meance it check data if found blank then move to second and at end provide me after blnk i case of same name.
    alwasy provide me data after scape blank cell and swap next row.

    Name Salary Attendace
    Ram
    Ram 4000
    Heera A
    Ram 3000 P
    Heera 2000 A
    Heera 1000 A
    Ram 500 A

    Name Salary
    Ram 4000 Result always this

    Name Attendace
    Ram P Result always this

    Name Salary
    Heera 2000 Result always this

    Name Attendace
    Heera A Result always this

    1. Still i dont recive any solutions

  43. Thank you for the detailed instruction for different uses of VLOOKUPs.
    I'd like to find out if I could use VLOOKUP to look for a value when a condition applies in the lookup table. For example, =VLOOKUP(Lookup_value_list, lookup_table!A1:D100, 2, false) Under column B, let's say it has certain number of Value As and certain number of Value Bs, I want to add a condition (like a filter to the lookup_table) to ask the vlookup funtion to only look for Bs in the lookup_table. How do I do this without applying for a filter before hand? Thank you in advance!I would appreciate your insights!

  44. Is it possible to import every Nth Cell from another Sheet. I am trying to import every 6th cell from Column C. I’ve tried doing this but I keep ending up with the imported data appearing every 6 rows. I then tried to sort the range this compiled the data but also alphabetised it which I don’t want. Thanks!

  45. Hello,

    I wanted to know on how can I pull data for a certain information like "XYZ" from the data provided below.

    Item Set Code Test
    ABC, IJK, RST, XYZ 5 2001 Major
    ABC 2 251 Major
    IJK 6 4001 Remission
    RST 6 9002 Depression
    XYZ 9 12003 Remission
    IJK, XYZ 10 8009 Remission
    ABC, RST 11 4007 Depression

    Thanks

  46. In the single cell we have multiple values like this CAA
    CBG
    ERT
    HGJ
    when i am trying vlookup 1st value (CAA) only coming , remaining values not come.

    1. Hello Thavakumar!
      For me to be able to help you, please describe your problem in more detail. What values are there in the cells you are applying your formula to?
      Are your 4 values typed in the same cell or in 4 different ones?
      What formula are you using to look for values?
      Please let me know. I think I can suggest a solution but some additional information is needed.

  47. Hi i want use vlookup formula but i have issue to find out result with two lookup value result will be same
    as a expamle :
    THIS IS DATA
    A B C
    ORENGE FROUIT
    APPLE FROUIT
    POTATO VEG
    TOMATO VEG

    a b
    1ST LOOKUP VALUE 2ND LOOKUP VALUE FIND OUT RESULT
    ORENGE APPLE ????????

  48. Good day, I am busy with big recons. I want to match info lines (A-X) with info lines (Y-AV) but my key codes is in G and AD). How do I do 'n v-lookup dat say "match code in G with Code in AD, if it matches in the same line 227 it must say yes and if it doesn't match in the same line it must say false. I hope I make sense.

  49. thank you so much.

  50. Hi
    I need to vlookup (one column have part numbers) and
    (another have part numbers in between - as separating 3 integers).
    Eg. 12345678
    123-456-78
    but both are same.
    Kindly assist me how to make it
    Thanx

    1. just add CONCATENATE before your vlookup

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 :)