Referencing values from different tables and ranges

[amaresh achar]

Hi..

I need help to develop an excel formula in referring values from different tables and ranges and add the value to basic size and place the results in respective cells.

the demo file is at below link, and also one small explanation of my requirement.

Kindly help... Thank you in advance.

Regards,
Amaresh.A.R

https://drive.google.com/open?id=1BK3FJRnyLOY7ugXGQSfy9IZLt8lvqKs3

 

[RasGhul]

Hi Amaresh,

Sample version attached, see if this suits.


https://www.dropbox.com/s/t5w0gwbs69pagdn/tolerance demo_JP.xlsx?dl=0

 

[amaresh achar]

Hi Amaresh,

Sample version attached, see if this suits.


https://www.dropbox.com/s/t5w0gwbs69pagdn/tolerance demo_JP.xlsx?dl=0

WoW.. thanks.. it works great...!!

 

[RasGhul]

You're welcome thanks for the feedback