Search results

HI Everyone @vletm when i accessed your file it opened with the ff: Stock Code Qty Unit Price 74004 10 1034.36 When I changed qty to 1 Stock Code Qty Unit Price 74004 1 #N/A It returned a #N/A error and that was the only reason for changing the formula. @Peter Bartholomew I love your...

HI vletm I changed the formula to =LOOKUP(LOOKUP(F2,J4:J7,H4:H7),J4:J7,I4:I7) and it works:) Now I just need to incorporate into my quote template. Will keep forum updated. Thanks to everyone for your assistance. This forum ROCKS Ciao for now(no guesses what i will be working on;)) Vernon

Going to give this a bash...and will advise...Thanks Peter

Me Again vletm For clarity in the file at present we have the ff QtyBreaks: 5 10 15 10000 As well as 10 30 50 10000 This might change in future but will always be four(4) breaks as per our administrator. I am looking for an "automatic fix" as if this works not everyone using the quote...

Dear vletm For the StockCodes yes, but not so for the QtyBreaks. Even in my original file that I uploaded there are different QtyBreaks. I would also like that should the file change to include more StockCodes and different QtyBreaks that when we refresh the information via ODBC that the file...

Thank you Vletm The pricing breaks given is what is set up in syspro and we just pull the info into excel...maybe I can add a colum to get back to the I green values....any suggestions Thanks again Vernon

HI and thanks to all for quick responses. Differing solutions to the same question and all work...Excellent. I am looking to use this within a quote template, and I might have worded my question incorrectly so apologies....quantities can be anywhere from 1 to 10000 and I need to get the price...

HI First time user, pls help. In attached file I need to lookup a stock code(in cell E2) in Column A, and return a price(in cell G2) from Column C) based on quantity (in cell F2) as per quantity break in Column B for each of the stock codes in Column A. Your assistance will be greatly...