Hello,

I have a spreadsheet with two different sheets.
Sheet 2 has Pipe Specs..

ie. sheet 2
column 2 has "names"
column 3 has "inches"
name1 32.1
name2 64.1
etc

sheet 1 has a lot more data. It has the pipe spec names as well... and
there is a formula that I created to grab data from sheet2 and put it in the
adjacent cell in sheet1.

so in sheet 1.. i say i have "name1"... the cell beside it contains a
formula that will automatically put in 32.1.

The formula i used is-

=IF(LOOKUP(E138,'Pipe Specs'!B:B)=E138,LOOKUP(E138,'Pipe Specs'!B:B,'Pipe
Specs'!C:C),"Not Found")

the problem i have is.. that when i add a new pipe spec in sheet2... it
comes up as "Not Found" on sheet1.... but all the older ones get the right
inches..

any help would be greatly appreciated. I think i am missing somethign simple.