Student using Excel

  LostNat86 11:27 19 May 2007

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

  VoG II 11:31 19 May 2007

Hello Natalie.

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

  LostNat86 11:44 19 May 2007

wow your a star thankyou so much!

  Abel 21:54 19 May 2007

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


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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Graphic tees: 14 best websites to find your next T-shirt

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017