If(vlookup or formula

[Jon3sy]

Hi there Gurus

I am trying to write a formula that is an if statement but also a vlookup and OR statement - so depending on what is in cell B6 (2 choices), if B6= choice 1 then I want my formula to vlookup the value in F21 in a table range and then returning value from column 9, OR if B6 = choice 2 then vlookup a different reference B21 in same table range and return value from column 10, and if B6 is blank leave blank.
So this was my attempt ...
if(or($b$6="R",vlookup($f$21,$F$2:$O$28,9,false),if($b$6="S",vlookup($b$21,$F$2:$O$28,10,false),"",)))))

Hope someone can make sense of my requirement
Cheers

 

[Shloime]

you wouldn't use OR for this, you'd use when you want the same results if any condition is met
this the one: =IF($B$6="R",VLOOKUP($F$21,$F$2:$O$28,9,FALSE),IF($B$6="S",VLOOKUP($B$21,$F$2:$O$28,10,FALSE),""))

 

[Jon3sy]

Wonderful worked perfectly, I was over-thinking it (as usual)
Thank you so much