EXCEL EXPERT TO CREATE FORMULAS
Budget: $10 – $30 USD
An excel expert is needed to create formulas so we can automate some cells to grab data from other cells/sheets and return a certain value.
Some examples of the Formulas Needed (there might be 2 or 3 more)
1. If Cell B3 starts with XXX then return XXX to E3 or if, etc..
2. If Cell B3 starts with XXX then return XXX to D3 or if, etc..
3. I3 "Products" sheet = Match text that exists in I3 against columns A and B in "Cat Reconcile" sheet
if match then replace value on I3 "Products" sheet with value in "Cat Reconcile" sheet column C3
if not match then return "error"
Some examples of the Formulas Needed (there might be 2 or 3 more)
1. If Cell B3 starts with XXX then return XXX to E3 or if, etc..
2. If Cell B3 starts with XXX then return XXX to D3 or if, etc..
3. I3 "Products" sheet = Match text that exists in I3 against columns A and B in "Cat Reconcile" sheet
if match then replace value on I3 "Products" sheet with value in "Cat Reconcile" sheet column C3
if not match then return "error"