Forum Discussion
JoeJr382018
Jun 01, 2019Copper Contributor
Need help creating a formula in excel
I need help creating a formula at incorporates the info in the list below the main table in the image above. Thanks
- Jun 01, 2019You may use this formula in H4:
=IF(B4=“Empty”,O$4,
IF(B4=“Loaded”, LOOKUP(F4,M$8:M$12,O$8:O$12),
“”))
JoeJr382018
Jun 02, 2019Copper Contributor
Thanks that worked perfectly
Twifoo
Jun 02, 2019Silver Contributor
It pleases me to know that!