IF statement with range
I know it's something obvious but I'm getting error messages, no results...
A B
Bob 1
Sue 7
Joe 2
I need to look at the entire range of col B and if it is = to 1, give me the
corresponding text in Col A. I was using =IF(B1:B3="1",A1:A3,"") but it's
obviously wrong. My whole goal is to look at col B, find the top 5 and give
the corresponding name sin col A. Any help would be greatly appreciated!
|