I have a spreadsheet created.
However, I need the formula to work off of text too, not just a number.
This is my formula:
=IF(AND(K5>0,L5>0,M5>0),ROUND(VLOOKUP(TEXT(K5,"00.000")&TEXT(L5,"0.000"),'Shape, Support Tooling'!A2:G19,5+M5,FALSE),0),"")
Where M5 is, is where I would need the column to have words in it instead of going off numbers
Solved by E. U. in 12 mins