About Us

Eduardo

your welcome thank you for letting me know

"Lisa Cowan" wrote:

Hi

I think I have fixed it - some how there was a drop down menu in the H
column of the Parts List so when I was inserting new items it was not able to
return the exact price. Well now I have removed this things seem to have
stabalised.

thanks for all your help

"Eduardo" wrote:

Hi Lisa,
could you forward a sample of you spreadsheet I will take a look, please in
the email mention this discussion group and the problems you are having
forward it to

"Lisa Cowan" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LOOKUP PROBLEM	Bill	Excel Worksheet Functions	1	October 16th 09 02:51 PM
Lookup problem	Esseja	Excel Worksheet Functions	4	January 31st 09 10:31 AM
Lookup problem	murrmeik	Excel Worksheet Functions	2	May 13th 08 07:33 PM
problem with v lookup	Elliott	Excel Discussion (Misc queries)	3	April 20th 06 12:06 PM
Lookup Problem	StephanieH	Excel Worksheet Functions	1	December 20th 04 06:17 PM

Menu

About Us