Hello!
I am trying to figure out how to insert data from 1 cell on one sheet to an empty cell on another sheet based on the scenario.
For example...
- I need to enter data on Sheet 1 from Sheet 2 based on the reference in Sheet 1
- So, if a cell in Sheet 1 says "Blue", I need the cell next to it to say "1"
- If a cell in Sheet 1 says "Red", I need the cell next to it to say "2"
And so on.
I may not need multiple sheets, so let me know if there's a more efficient way to say "If it says _____ then enter _______".
Thank you!
Bookmarks