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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?