Vlookup error

I have a combobox on cell d7 and is populated from a defined name list. This works fine

What needs to happen is when i select a clients name from the combobox it should populate cells
D8 with address
D9 with Suburb
D10 with Postcode
D12 with Phone No
D13 with Fax No
D14 with Email Address

I have inserted this formula in cell D8 =IF(A2="","",VLOOKUP(A1,Clients!$A:$G,2,FALSE))but can't get it to work

All the clients details are in a worksheet called Clients within the same workbook in the following cells

Cell A2 Clients Name
Cell B2 Address
Cell C2 Suburb
Cell D2 Postcode
Cell E2 Phone No
Cell F2 Fax No
Cell G Email Address

I know once the formula is correct in cell D8 i copy it to the other cells and change the column numbers

Suspect it needs to be:

... VLOOKUP(A2,Clients!$ ...

Regards

Change your column reference to the same as below and you'll be able to drag down and the column number will increment, it'll save you having to maniually change each formula VLOOKUP(A1,Clients!$A:$G,Rows(D$8:D8)+1,FALSE)

Didn't read the question properly last time; your client's name is in cell D7

Change it to:

... VLOOKUP(D7,Clients!$ ...

Regards

IF($D$7="","",VLOOKUP($D$7,Clients!$A$1:$G$1000,2,FALSE)
or if your combobox linked cell is a2
then
IF($A$2="","",VLOOKUP($A$2,Clients!$A$1:$G$1000,2,FALSE)

look at this

D8: =IF($D$7="","",VLOOKUP($D$7,Clients!$A:$G,ROW()-6,FALSE))

and drag down to D13

Just goes to show how valuable a sample workbook is ;-)

have a combobox on cell d7

no you don't!!!!!
you have a data validation drop down not the same thing as a combobox which i showed in my example
id prefer in d8
D8: =IF($D$7="","",VLOOKUP($D$7,Clients!$A1:$G1000,ROW(a2),FALSE))
dragged down then delete D10