Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Help me figure out an [Excel] Formula

psycojesterpsycojester Registered User regular
edited April 2010 in Help / Advice Forum
Basically i've got a E-business case study, it involves being given a workbook with a lot of functions missing in it and having to fill in the blanks and complete certain tasks we've been given with it. Atm a function is giving me some shit.

Basically there's a booking sheet with a Standard or Advanced booking fee, the type of fee is listed in a column in one sheet and the actual price is on another sheet. ATM I'm using an IF Function to identify if its standard or advanced and i want to them use the TRUE, FALSE responses to activate VLOOKUP formula to return the correct response.

This isn't working as planned and i'm hoping somebody could give me some advice on the correct formula. This is what i've got so far:

=IF(E2="ST",=VLOOKUP(B2,'Room Charges'!$A$3:$D$8,3),=VLOOKUP(B2,'Room Charges'!$A$3:$D$8,4))

Could somebody please tell me where i'm going wrong with this formula and now to correct it.

[SIGPIC][/SIGPIC]
psycojester on

Posts

  • SkyCaptainSkyCaptain IndianaRegistered User regular
    edited April 2010
    I'm pretty sure we're not supposed to do your homework for you, but you have 99% of the formula right. The problem is you have two extra characters that should not be in the formula.

    SkyCaptain on
    The RPG Bestiary - Dangerous foes and legendary monsters for D&D 4th Edition
  • Mr_GrinchMr_Grinch Registered User regular
    edited April 2010
    Yeah, you need to lop out those equals on the vlookup.

    Mr_Grinch on
    Steam: Sir_Grinch
    PSN: SirGrinchX
    Oculus Rift: Sir_Grinch
  • SkyCaptainSkyCaptain IndianaRegistered User regular
    edited April 2010
    Mr_Grinch wrote: »
    Yeah, you need to lop out those equals on the vlookup.

    SHAME! SHAME! You're not supposed to do their homework for them. :D

    SkyCaptain on
    The RPG Bestiary - Dangerous foes and legendary monsters for D&D 4th Edition
  • psycojesterpsycojester Registered User regular
    edited April 2010
    Cheers for the assistance Mr Grinch :D

    Works perfectly now.

    psycojester on
    [SIGPIC][/SIGPIC]
  • Mr_GrinchMr_Grinch Registered User regular
    edited April 2010
    SkyCaptain wrote: »
    Mr_Grinch wrote: »
    Yeah, you need to lop out those equals on the vlookup.

    SHAME! SHAME! You're not supposed to do their homework for them. :D

    But he threatened to beat me up and take my lunch money!

    Mr_Grinch on
    Steam: Sir_Grinch
    PSN: SirGrinchX
    Oculus Rift: Sir_Grinch
  • psycojesterpsycojester Registered User regular
    edited April 2010
    He didn't do my homework for me, he taught me an important life lesson about the placement of ='s signs.

    psycojester on
    [SIGPIC][/SIGPIC]
  • LaOsLaOs SaskatoonRegistered User regular
    edited April 2010
    Even then, that's usually an error that Excel will tell you about and offer to fix for you.

    LaOs on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum