Quote:
Originally Posted by Kakero
Okay, for some reason (I blame WoW) I completely forgotten how to do this.
Cell C8 : AGE
Cell C10 : PRICE
Age 1 = $100
Age 2 = $200
Age 3 = $300
etc etc
The question is,
If I type 1 at Cell C8, how to make Cell C10 to automatically display $100.
If I type 2 at Cell C8, how to make Cell C10 to automatically display $200.
etc etc
Thanks.
|
i believe its IF then formula do a search in excel. I used to do this in VB but that was years ago. its a dust pile in my brain somewhere