+ Reply to Thread
Results 1 to 4 of 4

Formula to pick data from a column then a row help :)

  1. #1
    Registered User
    Join Date
    01-25-2014
    Location
    Scottsdale, AZ
    MS-Off Ver
    Excel 2010
    Posts
    5

    Formula to pick data from a column then a row help :)

    The Door Styles are in a dropdown list in Column A7 on the order form, I have a dropdown for the species in Coumn B7 that both referecece my data sheet. What I need is the formula that finds DW1 then sees the species filter and finds that price and returns it. Thanks!

    Door Style Knotty Alder Clear Alder Poplar Rustic Walnut Rustic Cherry
    DW1 $204.88 $281.30 $232.15 $296.23 $292.25
    DW2 $220.50 $299.10 $177.30 $220.70 $216.50
    DW3 $203.00 $277.25 $158.75 $197.50 $193.75
    DW4 $203.00 $277.25 $158.75 $197.50 $193.75
    DW5 $234.25 $315.75 $191.75 $238.25 $233.75
    DW6 $228.00 $316.75 $187.25 $241.50 $236.25
    DW7 $208.00 $288.05 $165.15 $210.10 $205.75
    DW8 $195.50 $275.55 $152.65 $197.60 $193.25
    DW9 $233.63 $321.65 $192.70 $246.18 $241.00
    DW10 $170.50 $250.55 $127.65 $172.60 $168.25

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to pick data from a column then a row help :)

    One way...

    Data Range
    A
    B
    C
    D
    E
    1
    Style1
    Style2
    Style3
    Style4
    2
    Type1
    49
    24
    11
    13
    3
    Type2
    76
    37
    92
    2
    4
    Type3
    98
    46
    82
    6
    5
    Type4
    78
    49
    77
    66
    6
    7
    8
    Type3
    Style3
    82


    This formula entered in C8:

    =VLOOKUP(A8,A1:E5,MATCH(B8,A1:E1,0),0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    01-25-2014
    Location
    Scottsdale, AZ
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Formula to pick data from a column then a row help :)

    Tony this worked! Thank you very much! Erik

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to pick data from a column then a row help :)

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pick diff pick list as per column value
    By ROHAN999 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-10-2013, 12:10 PM
  2. Replies: 3
    Last Post: 05-21-2013, 06:02 AM
  3. [SOLVED] How to pick a value from a array of data corresponding to column and a row
    By chrismonica in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 04:21 PM
  4. pick data from a specific row/column (eg 10/B) related to active cell
    By zonino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2009, 04:01 PM
  5. Formula to pick last value in a column
    By jayschr in forum Excel General
    Replies: 6
    Last Post: 03-23-2009, 02:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1