Try:

=IF($A8="","",VLOOKUP($A8,'Equip Database'!$A$7:$L$1000,COLUMN(),0))

Regards

Trevor


"Richard P" wrote in message
...
I have two sheets, one has my equipment database and the other is the
results
"Quote sheet". in my Quote sheet I am using the:

=IF(ROW()-1MAX('Equip Database'!A:A),"",ROW()-7)

in the first colum and row 8 (A8), then use the:

=IF($A8="","",VLOOKUP($A8,'Equip Database'!A7:L1000,COLUMN(),0))

in the rest of the cells on the same row (B8, C8, D8 etc.)

if I enter a qty in the Equip Database Colum A, then I populate the rows
in
the the Quote sheet.

But it only retirves and up to row 27 of the Equip Database rows. It is
limited to around that phisical row and not the total amount of where a
qty
is entered.

Ex:

in Equip Database I enter qty in row 25 then it is sent to my Quote sheet.
If I enter a qty in row 30 it does not get sent to the Quote sheet. But if
I
enter a qty in row 10, 17 & 20 then it does.

Any sugestions?

Thanks in advance,