Dear All.

I currently use the below formula in Process Details of a 5 page quote
spreadsheet - the F column refers back to the Master parts list, column B and
the price in column H is returned and goes into column G on Process details.
the problem is we are still adding new items to the parts list and it is now
causing a problem when returning a correct price as it does not seem to be
tracking properly and returning a price from one or two lines up. To keep the
parts list in alphabetical order I am inserting lines to put the new items
in. It is only happening with the new items but not all of the new items.
Feels more like a ghost in the machine but I am sure that you guys have a
much more sensible explaination for it.

=IF(ISNA(LOOKUP(F564,Master!$B$5:$B$161,Master!$H$ 5:$H$161)),"",LOOKUP(F564,Master!$B$5:$B$161,Maste r!$H$5:$H$161))

thanks for any help you can give.
Lisa