Hi,
Im reasonably new to excel.
Im hoping someone can show me a formula to help me.
Is there a formula that i can put into cell B26 next to Brad White that if B4 has a value of 1 then it will = B6 on the Sydney points table. If the value of B4 is 2 then it will equal B7 from the Sydney points table. All the way down to a value of 24 that would = B29 from the Sydney Points table.
I have attached the file as well as the photos.
Every thing i know i have just learnt from google but Im not sure how to do this.
Thanks in advance.
Bookmarks