Excel--- Corresponding lists

  MAJ 22:47 10 Jun 04

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 04

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


  MAJ 23:09 10 Jun 04

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.

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…