Guzzlr
Well-known Member
- Joined
- Apr 20, 2009
- Messages
- 982
- Office Version
- 2021
- Platform
- Windows
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