Results 1 to 6 of 6

Need formula for price based on quantity and product name on a separate sheet.

Threaded View

alepoutre Need formula for price based... 08-10-2011, 04:18 PM
ZENITH Re: Need formula for price... 08-10-2011, 04:23 PM
alepoutre Re: Need formula for price... 08-10-2011, 04:37 PM
ZENITH Re: Need formula for price... 08-10-2011, 04:41 PM
alepoutre Re: Need formula for price... 08-10-2011, 05:02 PM
ZENITH Re: Need formula for price... 08-10-2011, 05:06 PM
  1. #4
    Registered User
    Join Date
    08-10-2011
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Need formula for price based on quantity and product name on a separate sheet.

    Quote Originally Posted by alepoutre View Post
    What do you mean by named ranges?
    I mean go to sheet 2, select A5:A7, go to formulas tab, define name STYLE

    then on sheet 1 on the style cell B5 select, and go to data tab, Data Validation, change to list, and put =STYLE in Source box. Then you create a new column to the right of it and put that code :
    =IF(B5<>"",VLOOKUP(B5,Sheet2!$A$5:$B$7,2,0))
    That will let you use a dropdown box to select the price per unit IF on sheet 2 the prices are right next to the style in column B, otherwise you need to change that range Sheet2!$A$5:$B$7 to go to the column your price is in and change the number 2 to the column number.

    Its a good way to do it that way you can use basic math in your budget field without it getting messy.
    Last edited by ZENITH; 08-10-2011 at 04:44 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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