One more method assuming your table width is more than 2 columns.

Select D1:H1

In D1 enter =VLOOKUP(K4,$A$3:$C$714,{2,3,4,5,6},FALSE)

CTRL + SHIFT + ENTER as it is an array formula.

BUT note that your original lookup table was only 3 columns wide so you would
have to increase that table size to have any need to copy across more than two
columns.


Gord Dibben MS Excel MVP


On Tue, 20 Nov 2007 16:00:01 -0800, Jim Thomlinson
wrote:

Ooops. I was thinking about the first post where the op was copying down
rows... My Bad. Thanks for catching that...

To avoid the performance hit associated with column() and row() functions
(volatile) you might consider just putting the number you want into a cell
and dragging it to increment the value. You can then just (relative)
reference the cell.