Dear All,
I have this following table
<tbody>
</tbody>
I want a formula which will the Amount Column value to Cell "C1" when i enter any value from Item Column in cell "A1" & "B1".
For example
if i put Rent-A-Cab in cell A1 & Operational in B1 then the return value should be 0.
if i put Office in cell A1 & Operational in B1 then the return value should be 80.
Thanks
I have this following table
Item | Group | Amount |
Rent-A-Cab | Operational | - |
Office | Operational | 80.00 |
TV | Bridal | - |
Legal | Quality Assurance | 100.00 |
Traditional | 100.00 |
<tbody>
</tbody>
I want a formula which will the Amount Column value to Cell "C1" when i enter any value from Item Column in cell "A1" & "B1".
For example
if i put Rent-A-Cab in cell A1 & Operational in B1 then the return value should be 0.
if i put Office in cell A1 & Operational in B1 then the return value should be 80.
Thanks
Last edited: