vendredi 15 mars 2019

Excel Multiple Vlookup's based on cell values with sums

I am trying to carry out 2 different vlookups, based on 2 different cell values, then divide the resulting figure by a cell value. I have been playing around with this for a while, I am also using helper cells, but I am still struggling to get it to function correctly.

Spread Sheet Example

Formula I am trying to get to work.

=IF(J2="Portrait",ROUNDDOWN(VLOOKUP("Middle",B:C,2,FALSE)/$J$5,0),ROUNDDOWN(VLOOKUP("Middle",B1:C4,2,FALSE)/K$5,0))

The cell value for J2 will either be Portrait or Landscape.

Any help would be appreciated. Thanks, Steve

Aucun commentaire:

Enregistrer un commentaire