ps, you could use this convulted formula, too:

=VLOOKUP(A3,Sheet1!$T:$X,COLUMN(Sheet1!$V:$V)-COLUMN(Sheet1!$T:$T)+1,FALSE)

surg4u1975 wrote:

Inserting between T and X.

--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718
View this thread: http://www.excelforum.com/showthread...hreadid=484108

--

Dave Peterson