I don't understand the layout of your data, but for some nice instructions on:

=vlookup()
and
=index(match())

Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

TARZAN wrote:

I have on Sheet 1:

Part # Line#
TTT ?

On Sheet 2:

Column A B C
Line # 1 2 3
Part #'s WW SS DD
FF TT HH
...

I want to put a formula on sheet 1 to give me the line # from sheet 2.

--
Thanks

--

Dave Peterson