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

a reply would be greatly appreciated

thank yo

--
SClingerma
-----------------------------------------------------------------------
SClingerman's Profile: http://www.excelforum.com/member.php...fo&userid=2827
View this thread: http://www.excelforum.com/showthread.php?threadid=47839