Excel question - Imput in cell - next cell auto fills

  Dirty Dick 14:50 04 Apr 2014
Locked

Hi A simple question, I hope the answer is as simple !

If I enter a name in a cell i.e. Bill Bloggs, how can I make the adjacent cell put another name i.e. John Smith? There are about 75 names to put in the first cell.

Thanx in advance

  hastelloy 15:39 04 Apr 2014

I think you'll need to clarify your question.

Do you mean there are about 75 names to put in the first column (or row)?

Where is the information for the auto-fill coming from?

Please explain what you are trying to achieve.

  compumac 16:17 04 Apr 2014

You will need the =IF(..... IF, by inputting Bill Smith in cell A1 then in Cell B2 put Cyril Brown etc. Not quite as straightforward as that but it is the IF scenario that you need.

  compumac 16:18 04 Apr 2014

You will need to nest several IF's to do this though.

  Dirty Dick 17:26 04 Apr 2014

If I have 75 names (in my head) and their appropriate partners names (in my head) . When I type say "Bill Bloggs" in Cell A1, how do I get to get his wifes name in Cell B1 ?

Thanx for your responses

  Zak 17:34 04 Apr 2014

Which ever way you do this you will first of all need to set up a table with two columns( Name and |Partner) and list all the couples. Are you going to be referring to this list often / for other uses?

The next stage would be to do a lookup function for cells in column B.

How to use the LOOKUP function in Excel

  Woolwell 18:25 04 Apr 2014

No device is yet a mind reader. The data input has to be done by you, normally by typing.

  wee eddie 19:23 04 Apr 2014

Woolwell --- Beat me to it.

If you put the Surname first. As in 'Bloggs, Bill', an Alpha Search should do the trick

  bumpkin 19:48 04 Apr 2014

Why not just type the partners name into the next cell.

  hastelloy 10:22 05 Apr 2014

Woolwell, wee eddie, bumpkin

This is what confused me - I don't have psychic powers either!

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone