This should be easy, I'm just drawing a blank. How do I put information in cell A1, look down column B until the number matches, and display the information in column C that corresponds to the match in column B?
quote:It takes 5 minutes to learn vlookup. Stupid reason for a no hire.
VLOOKUP is the quintessential analyst tool. I'm an analyst now but if I have to hire anyone I'll really just sit them down and make them use that. If they can't... no hire.
quote:
Index match ftw
quote:
Index match ftw