none
VLookup from two columns

    Question

  • =VLOOKUP(Sheet3!$A2,'Budget Builder'!$B:$U,4,FALSE)

    How can I use a simular expression to search for data in Column B and T?

    Column B has project Names (three lines of data for each name where T is unique)

    Column T has Type (Capital, Passings, and Miles lines for each Project Name)

    I guess I am looking for a nested VLookup, but I don't know how I would do that.

    Wednesday, November 20, 2013 9:19 PM

Answers

All replies

  • Hi Matzke,

    The simplest way is to add a new column  that combines the two columns an then use your VLookup on that.

    eg in Column Z row 1 formula: = B1 & T1


    Brian, ProcessIT- Hawke's Bay, New Zealand

    Wednesday, November 20, 2013 9:44 PM
  • I tried that, but two issues:

    1.  This is pulling from a sheet I cannot add to.

    2.  When I did try to add a column with the two combined, Vlookup does not work unless I copy and paste values (vlookup can't find values from formulas)

    Wednesday, November 20, 2013 9:47 PM
  • 1/. Then in your Destination sheet combine the two columns and add the wanted result column then do the VLookup.

    2/. Vlookup CAN indeed find values in Calculated fields. perhaps you had calculations set to manual?

    An alternative would be a VBA Code Loop to Find your wanted value then test if the Next column also matches...


    Brian, ProcessIT- Hawke's Bay, New Zealand

    Wednesday, November 20, 2013 9:59 PM
  • with my constraints of pulling from a sheet I cannot modify, it does not.

    I did find the solution on youtube:

    {=INDEX('Budget Builder'!F:F,MATCH(A2&C2,'Budget Builder'!B:B&'Budget Builder'!T:T,0))+0}

    REF:  http://www.youtube.com/watch?v=Q_7M-DRNPCI#t=187

    • Marked as answer by Matzke Wednesday, November 20, 2013 11:20 PM
    Wednesday, November 20, 2013 11:20 PM