First, I think the old format is better. In fact, I'd spend some time to make
the new page look like that old page. If you happen to sort that new page, you
could be in big trouble!

But this might work:
=index(sheet2!a:a,match(a1,sheet2!a:a,0)+1)
It looks for the exact match, then adds one to the row where the match was
found.

Debra Dalgleish's has some notes you may like:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))



SClingerman wrote:

I am new to excell use, and i need some help.
i have a spreadsheet that is front page with lookup formula's, now the
part i have trouble with is that i need to change the location of the
lookup. from one page to a better page. the old page was set up to
search a column to find a part number then with the row found it next
search to find a number in the next column that was my inventory. the
new page is set up different with the part number in the same place but
the inventory is directly underneath it in the next row. how can i
search by range to locate the part number then tell it to read the very
next row?

a reply would be greatly appreciated

thank you

--
SClingerman
------------------------------------------------------------------------
SClingerman's Profile: http://www.excelforum.com/member.php...o&userid=28271
View this thread: http://www.excelforum.com/showthread...hreadid=478396

--

Dave Peterson