Hi Newtonboy,

You probably have a solution to this problem now - but in case you
don't, here's my suggestion with an attached example using your file.

"=VLOOKUP($A9,'Pine Master Sheet'!$A$9:$V$210,COLUMN(B9),FALSE)"
After being modified for your file, this formula can be copied down as
many rows & across as many columns as required.
(See the attached file for more explanation)

The above corrects a slight error in Gord's suggested formula & should
stop the "#N/A" problem by adding a dollar sign in front of the lookup
reference, ie "$A9" as above. This forces the formula to look up the
log id from column A no matter which column the formula is in.
I have also made another change to make it easier for copying the
formula across the columns by using the "column" function as shown
above. This stops the need for changing the column reference in the
vlookup formula when it is copied across the range of columns.

Hth,
Rob Brockett
NZ


+-------------------------------------------------------------------+
|Filename: Sample with suggested solution.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4176 |
+-------------------------------------------------------------------+

--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=492821