Hello All;
I'm using;
The problem is the lookup ID of Row 11. Row 11 is looking at the name of Sam. If this name, Sam, moves, the H-Lookup no longer works.
I've cured this problem using VBA to make it more dynamic, as Sam moves, Sam is still found. However, I'm trying to keep it non-VBA for this particular instances...I don't know how to do this. Is there a Find function I can use with H-lookup?
Thanks for the help
I'm using;
Code:
=IFERROR(HLOOKUP(B$32,$19:$30,11,FALSE),"")
The problem is the lookup ID of Row 11. Row 11 is looking at the name of Sam. If this name, Sam, moves, the H-Lookup no longer works.
I've cured this problem using VBA to make it more dynamic, as Sam moves, Sam is still found. However, I'm trying to keep it non-VBA for this particular instances...I don't know how to do this. Is there a Find function I can use with H-lookup?
Thanks for the help