I'm at work right now and i'm being asked to make a formula for excel.
The specifics are:
price : (need to fill in)
price with substractions etc : (need to pull from different tab)
price : 1
subst : A
Price : 2
subst : V
Price : 3
subst : G
So if i enter "1" in tab1 the 2nd cell has to pull the A from tab 2
if i enter "2" in tab1 the 2nd cell has to pull the V from tab 2 etc etc
I can not for the life of me find this on internet and was wondering if the ngu community could help me out.