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 02:11 AM.
Try
=INDEX(AG5:AR500,MATCH(A1,AG5:AG500,0),12)
where A1 is the material whose price you want
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
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.
-This is my Greek whisper to Europe.
--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.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
AR5, copy down...
=IF(COUNT(AI5:AM5),LOOKUP(9E300,AI5:AM5),"")
This will give the last number in a row
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks