Hi

Sorry to be a pain but your formula is doing the same thing, I have two sink
parts which I have added to the list. when I add the first one the correct
price appears when i select it in the Process details sheet, however when I
add the second item below the first one on the Parts list the price on the
Process Details for the previous item changes to the price of the second item
which I have just added to the Parts list i.e it takes the price of the item
above.
Like I said if you know what is causing this it may not require a change in
formula.

thanks

"Lisa Cowan" wrote:

Thanks for that. Do you happen to know why this is happening with my existing
formula?

As far as the alphabetical order is concerned it is more for ease of search
when you are looking for a part rather than in relation to the formula.

thanks

"Eduardo" wrote:

Hi, try

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


you don't need to have the list in alphabetical order

"Lisa Cowan" wrote:

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