Hi all, please help. I need to find what is the rate (Trainer and Non trainer is of a different rate) for each installer for different product and different sq ft. However, as the sq ft is in a range, i can't seem to do xlookup with the correct answer. I have attach the workign file for reference.
Eg, =(Ridoy With Skirting 435sq ft, Non trainer) - Correct rate should be 0.09.
Thank you!!
Bookmarks