Post: Excel formula
03-23-2017, 07:36 AM #1
xkoeckiiej
At least I can fight
(adsbygoogle = window.adsbygoogle || []).push({}); Hellooooo,
I'm at work right now and i'm being asked to make a formula for excel.
The specifics are:

Tab1:
price : (need to fill in)
price with substractions etc : (need to pull from different tab)

Tab2:
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.
04-24-2017, 06:01 PM #2
EGA-Scarface
PS4 Trophy Seller
I think I'm following what you are asking. If you just click on the end desired cell and type = you should be able to just click on the other tab and the cell you want to pull from. If I'm not tracking correctly, let me know.
04-24-2017, 07:14 PM #3
Hydrogen
Super Mod
Originally posted by Scarface View Post
I think I'm following what you are asking. If you just click on the end desired cell and type = you should be able to just click on the other tab and the cell you want to pull from. If I'm not tracking correctly, let me know.


Please make sure to quote the user next time sir.

Copyright © 2024, NextGenUpdate.
All Rights Reserved.

Gray NextGenUpdate Logo