jardenp
Active Member
- Joined
- May 12, 2009
- Messages
- 373
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
This came up from trying to answer another question in this forum:
Is it possible to have a VLOOKUP or something like it that matches the contents of two cells and returns that of a third? For example:
A - B - C
1 - a - i
2 - b - ii
1 - c - iii
2 - d - iv
The lookup for "1" and "a" would return "i"
The lookup for "1" and "c" would return "iii"
etc.
I know you could do this by concatenating columns A and B and then running a normal VLOOKUP on the combined values, but is it possible to do this without concatenation?
Thanks!
Is it possible to have a VLOOKUP or something like it that matches the contents of two cells and returns that of a third? For example:
A - B - C
1 - a - i
2 - b - ii
1 - c - iii
2 - d - iv
The lookup for "1" and "a" would return "i"
The lookup for "1" and "c" would return "iii"
etc.
I know you could do this by concatenating columns A and B and then running a normal VLOOKUP on the combined values, but is it possible to do this without concatenation?
Thanks!