Dear sir,with best regards,i need your help to get last price from this schedule of data :
-the range(ag5:ag500) has the names of materials.
-the range(ai5:am5) has the prices of each material.for example (A) material has these prices continually 1.6,1.8,1.9) i need the result as ( 1.9 ).
-the range(ar5:ar500) the last prices from above second range,and the cells are ( empty ) if there is no prices.
your help is very appreciated.
Last edited by tofimoon4; 01-23-2012 at 01:11 AM.
Try
=INDEX(AG5:AR500,MATCH(A1,AG5:AG500,0),12)
where A1 is the material whose price you want
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
Dear sir,with my thanks,i tried to use the formula on my example,but failed.
I enclosed herewith the example asking you kindly to help by your formula.
Many thanks in advance.
Hi
Maybe in AR5, try MAX formula. =MAX(AI5:AM5)
Copy down.
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Hi,
AR5, copy down...
=IF(COUNT(AI5:AM5),LOOKUP(9E300,AI5:AM5),"")
This will give the last number in a row
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Dear sir,many thanks for help,the formula works very nice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks