Forum Discussion
Solved
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
- You may use this formula in H4:
=IF(B4=“Empty”,O$4,
IF(B4=“Loaded”, LOOKUP(F4,M$8:M$12,O$8:O$12),
“”))
You may use this formula in H4:
=IF(B4=“Empty”,O$4,
IF(B4=“Loaded”, LOOKUP(F4,M$8:M$12,O$8:O$12),
“”))
=IF(B4=“Empty”,O$4,
IF(B4=“Loaded”, LOOKUP(F4,M$8:M$12,O$8:O$12),
“”))
- Thanks that worked perfectly
- It pleases me to know that!
