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.

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