Yogia ... sorry again for my late reply but today I am travelling in Canada ...
Regarding to your suggestion, I must tell you that you are a genious !! and I am still amazed that IT WORKED GREAT !!! The only problem that still persists is that I am still getting a "0" value on cell F3 ?? ...
Yogia thank you very much for your follow up and sorry for not being able to reply earlier.
Regarding to your comments I have copied the formula you suggested from F2 to F6 in ws#1 ... and I'm still not sure what I am doing wrong but I keep getting "0's" as a result on every one of these cells...
I have tried both suggestions but none worked. It seems that the MAX array formula won't do it ??... Do you think that VLOOUP might do it ?
Thanks for your advise.
JPS
Yogi thanks for your advice. Unfortunately I did try what yo suggested but for some reason did not work.
Below is the exact example of what I am trying to do;
ws#1;
Grade Awidth Thick(mm) Length Price Tot_Cost
HD_PREM 4 5.50 96.00 $160.00
HD_UTIL 4 5.50...
Problem; When values in column#1 & #2 of ws#1 match with values in column#1 & #2 of ws#2 the funtion returns the value in column#3 of ws#2 to column#5 of ws#1.
Ex; If A2=10 & B2="L" in ws#1 then the funtion returns 700 to cell# E2.
Wsheet#1;
A B C D E
1 0 J...
