I really enjoy using index match for look up purposes, i find it very useful but i am struggling with this one instance. I have a formula in column T that reads =LEFT(U7, LEN(U7)-1) and generates a number for me. I want to Index match off of this number but it is not working and only returning N/A. I know my index match formula is correct but the only thing i can assume is it cant generate off this formula but i generate off of formulas all the time so idk why this is an issue this time. Please help!!
Thanks!
Thanks!