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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

New MacBook Pro 2017 release date, UK price and tech specs: Kaby Lake MacBook Pro to launch in…