Mutliple IF+VLOOKUP Formula help!

Hi!

I am new here, so apologies in advance if I miss any info you peeps may require:

=IF(Q27="","",IF(R27="",VLOOKUP(Q$27,'Formula Data'!A14:Z38,13,FALSE),(Q$27,'Formula Data'!A14:Z38,13,FALSE)*R27))

If Q27 is empty, I want my cell (that I am formulating from) to be empty. If it is not empty then I want it to look into R27, if R27 is empty, then I want my cell to have basic vlookup in from Q27, and if R27 is not empty, then I want the vlookup from Q27 multiplied by R27.

Thank you!

You almost had it, you just left of the actual vlookup from the last one..

=IF(Q27="","",IF(R27="",VLOOKUP(Q$27,'Formula Data'!A14:Z38,13,FALSE),VLOOKUP(Q$27,'Formula Data'!A14:Z38,13,FALSE)*R27))

Omg! -_-

So stupid of me, thanks!! :P

You're welcome.

You can improve that a bit by re-arranging how/where the 2nd if checks for R27 being blank.
So long as the result of the vlookup is always a number, regardless if R27 is blank or not.

=IF(Q27="","",VLOOKUP(Q$27,'Formula Data'!A14:Z38,13,FALSE)*IF(R27="",1,R27))