+ Reply to Thread
Results 1 to 4 of 4

Proper formula syntax here?

  1. #1
    Registered User
    Join Date
    07-22-2008
    Location
    WV
    Posts
    70

    Proper formula syntax here?

    What would the proper syntax be for this formula or is this even possible with formula? Hopefully, this is enough to give you the gist of what I am trying to do.

    IF A1 = $B$1 then C1 = $D$1 OR IF A1 = $B$2 then C1 = $D$2 OR IF A1 = $B$3 then C1 = $D$3

    Column B references items (i.e. Apple, Banana, Pear) and column D references prices ($1.20, $1.50, $0.75)

    So if A1 is "Apple" then C1 is $1.20 but if A1 is "Banana" then C1 is $1.50.

    Any help is much appreciated. Thanks.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Proper formula syntax here?

    =if( a1=$b$1,c1=$d$1,if(a1=$b$2,c1=$d$2,if(a1=$b$3,c1=$d$3,"")))

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: Proper formula syntax here?

    Use VLOOKUP function:

    =VLOOKUP(A1,$B$1:$D$3,3,0)

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Proper formula syntax here?

    or in C1 =INDEX(D:D,MATCH(A1,B:B,0))

+ 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. Help with proper syntax for an IF(AND formula construct
    By indians207 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-09-2017, 03:39 PM
  2. Proper If formula syntax for above and below number
    By Smasen91 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-24-2016, 08:51 AM
  3. Proper syntax for R1C1 formula in VBA
    By hbs1558 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2015, 08:40 AM
  4. Proper formula syntax for an AND statement?
    By redsab in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2013, 10:58 AM
  5. Proper syntax for EV(Expected Value) formula
    By Noobraino in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2012, 09:01 PM
  6. Proper syntax for a time formula
    By nicolelschramartin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-07-2012, 07:16 PM
  7. [SOLVED] Proper syntax with formula in VBA
    By kcleere in forum Excel General
    Replies: 3
    Last Post: 09-06-2012, 10:44 AM

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