Auto-complete for multiple cells in a row? ie, name/address

[GLO]

Hi,

I have a spreadsheet that i enter receipt data into.

The columns comprise of
Name, Company, Address 1, Address 2, Suburb, State, Postcode, Amount.

When i enter someones name, it can autocomplete for that single cell, but i would like to set up excel so that the chosen other cells will automatically update also, since the data is already in the spreadsheet.

Thanks in advance for your help!

[Bryan Hessey]

Hi,

I have a spreadsheet that i enter receipt data into.

The columns comprise of
Name, Company, Address 1, Address 2, Suburb, State, Postcode, Amount.

When i enter someones name, it can autocomplete for that single cell, but i would like to set up excel so that the chosen other cells will automatically update also, since the data is already in the spreadsheet.

Thanks in advance for your help!

Hi,

Perhaps along the lines of, when you complete a name in A1, then in B1 the formula

=IF(A1="","",IF(ISERROR(VLOOKUP(A1,Sheet2!A:D,2,FALSE)),"",VLOOKUP(A1,Sheet2!A:D,2,FALSE)))

and in C1 similar with 3,False etc

hth
---

[GLO]

Hi,

Perhaps along the lines of, when you complete a name in A1, then in B1 the formula

=IF(A1="","",IF(ISERROR(VLOOKUP(A1,Sheet2!A:D,2,FALSE)),"",VLOOKUP(A1,Sheet2!A:D,2,FALSE)))

and in C1 similar with 3,False etc

hth
---

Thanks I will give that a try.

BTW why does it refer to sheet 2?

[Bryan Hessey]

Thanks I will give that a try.

BTW why does it refer to sheet 2?

Hi,

you need a place to store the details, Name, Address etc, Sheet2 was just an example.

replace 'Sheet2' with the location of your table.

---