If the IF function result is false then check the next cell until get a true result

Hello,

I am trying to use the IF function to return names from column A where column B ="R". I need to remove the false or blank cells where column B does not = "R" so I just have the appropriate names (I know I could just filter but I need this to be automated in another sheet)

eg
Original Data
Column A Column B
1 Mike R
2 Stephen
3 Lisa R
4 Graham
5 Sarah
6 Nicola R


What If Returns
Column A
1 Mike
2
3 Lisa
4
5
6 Nicola


What I want
Column A
1 Mike
2 Lisa
3 Nicola


Hope this makes some sense to someone!!!

Thanks in advance