Forum Discussion
VLOOKUP help required
I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do. On the main worksheet I have populated the Project Category using VLOOKUP based on the ...
Please convert all your lookup tables to Table Format [Use Ctrl+T] and then use XLOOKUP as nested formula [Like the way you called nested VLOOKUP] and problem will solve. let me know for a quick connect by sharing your screen, I can help you.
Thanks