samedi 28 mars 2015

How do I use a function to insert a cell value into another cell?

enter image description here


I was wondering is there any formula that can allow me to do: I would like Excel to read whatever is in H5 (which is 12-52) and check the following conditions:



If H5 equals H4 then take whatever is in N4 and insert it into I5
If H5 equals O4 then take whatever is in U4 and insert it into I5
If H5 equals V4 then take whatever is in AB4 and insert it into I5
If H5 equals AC4 then take whatever is in AI4 and insert it into I5


As you can see H5 equals AC4 so take value 80 from AI4 cell and insert it in I5 cell and discard every other conditions.


Aucun commentaire:

Enregistrer un commentaire