View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JN JN is offline
external usenet poster
 
Posts: 29
Default 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!