Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 262
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a merged cell from a1 to c3 - the value in that cell is "5". Column A, B and C (under that merged cell) is filled with various values.
If I do a Hlookup on the value 5, it automatically returns the values stored in column A, is it possible for me to return the value that is found in column B rather than A?
I have a merged cell from a1 to c3 - the value in that cell is "5". Column A, B and C (under that merged cell) is filled with various values.
If I do a Hlookup on the value 5, it automatically returns the values stored in column A, is it possible for me to return the value that is found in column B rather than A?