Age Bracket using Lookup formula?

Hi I'm wondering can anyone solve this for me its task 5 and I don't know how to solve anyone can anyone give me a hand
? Its a file below thanks in advance

Age Bracket (D9) ===> =INDEX($A$2:$A$5,MATCH(B9,$B$2:$B$5))

Can you work out the other columns from that?

Hope this helps.

Pete

Here's my version. I've made the assumption that if Column C states a car park is not needed then the fee for parking will not be charged... I might be wrong in that assumption though.

Only thing that may raise an issue is if you needed to do this actually using LOOKUP rather than anything else.

popipipo that was excellent thanks tough as BadlySpelledBuoy stated Column C states a car park is not needed then the fee for parking will not be charged i have to leave as 0 what would be formula then and thanks to everyone i don't have a clue,how uses get so good at excel any recommended books etc and yes I've to use LOOKUP BadlySpelledBuoy

LOOKUP or VLOOKUP?

Any of vlookup hlookup or lookup

This thread sounds like a school assignment or homework. Search the FAQ for Homework to see what the Forum's stance is on that.

Pete

Hi Pete it's not an assignment my lecturer asked us to have a crack at this workbook but never thought us this its just to try but I want to know Formula's/functions.
What would you recommended as book or ?

Now completed using VLOOKUP. Because you cannot automatically look LEFT in a VLOOKUP I've combined it with CHOOSE in order to look up the age bracket. It's scruffy but works. I much prefer the INDEX/MATCH approach.

Also provided an alternative solution to Task 1.

Originally Posted by BadlySpelledBuoy

Now completed using VLOOKUP. Because you cannot automatically look LEFT in a VLOOKUP I've combined it with CHOOSE in order to look up the age bracket. It's scruffy but works. I much prefer the INDEX/MATCH approach.

Also provided an alternative solution to Task 1.

Thanks so much for All your help now i just have to learn thé formulas myself,would Amy1 recommend à book or somewhere online ? Thanks everyone

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete