Excel help...

D18241

D18241

D18241

Associate
Joined
4 May 2004
Posts
2,029
Location
England (sheffield)
Wondering if any one could help me out on this / if its possible

I want to get maybe 10cells veritcal to add up on a sum in A2 which i can do , but then i was wondering if i can get another cell to pull up text from page2 relevent to the sum.

Say the total of below is in the cell
A2 = 10
A2 = 30

it would pull the text from page 2 for 10 which might be text1 , if was 30 would say text2
 
Although that's incredibly confusing, and probably better to upload the sheet, are you thinking something like

=IF(A2=10,Sheet3!B1,IF(A2=30,Sheet2!B2,))
 
at work atm so cant upload ill have to do it when i get home , but =IF(A2=10,Sheet3!B1,IF(A2=30,Sheet2!B2,)) is what i am after more aless but i could end up with like 30 rows that i need it to pull from
 
You must log in or register to reply here.
Back
Top Bottom