Results 1 to 2 of 2

Drop down or lookup table help

Threaded View

karleen77 Drop down or lookup table help 07-28-2007, 08:25 PM
Ron Coderre Drop down help - Maybe lookup... 07-28-2007, 10:11 PM
  1. #1
    Registered User
    Join Date
    07-23-2007
    Posts
    6

    Exclamation Drop down or lookup table help

    I have no idea of how to do want I want.

    I have a workbook with 2 sheets. Sheet 1 is name quote and sheet 2 is named vendor price.

    SO vendor price is a table Column A is a list of items the vendors colors and Row 1 is all the sizes, and the rest of the cells has the pricing to match each size and color.

    Then on sheet quote I made drop down list in A1 and B1. A1 has Color and B1 and Size, now in C1 I want it to automatically show the price that would be in the matching cell on the table I used to create the drop down lists.

    I have attached the the for you to look at too - maybe that will help.

    I just don't know how to get A1 + B1 to look up the matching cell.

    Any help would be great!

    Thanks,
    Karleen
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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