Excel: VLookUp solves a potential Nested IF problem.
- by Mike
I manually enter numbers on one cell according to text values in the cell adjacent to it. Is there a way to use the IF function to help me manage this? The text is automatically generated with a report but I put the numbers in manually in Excel.
Example of my weekly boredom below:
number Text in Cell
3 Order A
3 Order A
1 Order C
2 Order B
3 Order A
1 Order C
2 Order B
2 Order B
HELP! My eyes and soul hurt each time I need to do this.
Thanks
Mike