Need to multiply a VLOOKUP value then divide that value, then multiply that value

[debbiemez]

I'm trying to return a value in sheet ABH Cell D15 doing a VLOOKUP.

=VLOOKUP(D189,'Data Sheet'!A16:B216,2,FALSE)

Then I need to take that value and multiply it by Value/$per share value in Data Sheet Cell B11
Then divide that value by the value in Data Sheet Cell B218
Than Multiply that value by the value in ABH Sheet cell D190

I can return the value by VLOOKUP but have no idea how to formulate the multiply, divide, multiply.

Any help would be appreciated.

[Glenn Kennedy]

Hi there... and welcome to the Excel Forum. Try this out.

[Tony Valko]

I didn't download your file.

Try it like this...

=((VLOOKUP(D189,'Data Sheet'!A16:B216,2,FALSE)*Data!B11)/Data!B218)*ABH!D190

[debbiemez]

Tony,
Thanks for the help. That worked. Now I'm trying to add the IFERROR function and just cannot seem to get it. This is the formula:

=((VLOOKUP(F189,'Data Sheet'!$A$16:$B$216,2,FALSE)*'Data Sheet'!$B$11)/'Data Sheet'!$B$218)*ABH!F190

[samba_ravi]

=iferror(VLOOKUP(F189,'Data Sheet'!$A$16:$B$216,2,FALSE)*'Data Sheet'!$B$11/'Data Sheet'!$B$218*ABH!F190,"")

[Tony Valko]

Like this...

=IFERROR(((VLOOKUP(F189,'Data Sheet'!$A$16:$B$216,2,FALSE)*'Data Sheet'!$B$11)/'Data Sheet'!$B$218)*ABH!F190,"")

[debbiemez]

Tony,
YES! I just couldn't get it to work properly. Thank you for all your help. Very much appreciated.

[Tony Valko]

You're welcome. Thanks for the feedback!