There are two ways of "moving" your calc
down the pipeline -- via Join or via Blend,
both making a LOOKUP() Table Calc redundant.
Please find the attached (based on your data).
Lookup_YF.twbx 89.8 KB
Thanks a ton Yuriy! It is such a wild experience seeing how other people's mind works
Himanshu, you're welcome.