Excel--- Corresponding lists

  MAJ 22:47 10 Jun 2004
Locked

I have a list of 10 names in Column A (A1:A10) and a corresponding list of those people's favourite colour in Column B (B1:B10). If Bob's name is chosen, can I get his favouite colour, from Coloumn B, returned in another cell, C1, for example?

  VoG II 22:55 10 Jun 2004

I'm not sure what you mean by "chosen".

=VLOOKUP("MAJ",A1:B10,2,FALSE)

  MAJ 23:09 10 Jun 2004

You never cease to amaze me, VoG™, of course you've hit the nail on the head again, that's working perfectly. Many thanks again, VoG™. :-)

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

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?