Excelllllllllllllllllllll
Board Regular
- Joined
- Jun 13, 2017
- Messages
- 108
Title says it all - I need help finding a workaround to the cell limit of VLOOKUP.
Let's make it simple:
Column A = Names
Column B = Birthdays.
Cell C1 = Blank cell to input name.
Cell C2 = VLOOKUP of C1 in A:B,2
How do I get this to work with more than 250 entries in the same sheet?
10K, for example?
Thank you!
Let's make it simple:
Column A = Names
Column B = Birthdays.
Cell C1 = Blank cell to input name.
Cell C2 = VLOOKUP of C1 in A:B,2
How do I get this to work with more than 250 entries in the same sheet?
10K, for example?
Thank you!