Student using Excel

  LostNat86 11:27 19 May 07
Locked

Hello im Natalie.
Im a student at Uni and have a workplacement where i stupidly agreed to set up a spreadsheet on excel.
I just cant remeber how to relate 2 lists, so i have a list of foods say cheese, ham, lettuce tomato, and when i select one i want the price to automatically appear.
Please can anyone help me
Thankyou!
x

  VoG II 11:31 19 May 07

Hello Natalie.

Take a look at VLOOKUP - there is a tutorial click here under 'Advanced Excel Functions'.

  LostNat86 11:44 19 May 07

wow your a star thankyou so much!

  Abel 21:54 19 May 07

A terrific link VoG™, I've bookmarked it!

Abel

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017