Another Nesting IF Statement Problem

  • Thread starter Thread starter bigwilly11189
  • Start date Start date
B

bigwilly11189

Ok, I have read others problems but they haven't helped, so here is m
problem. I have a 4 main worksheets that pull data from the other 20
worksheets in the Excel Book. I tried to use the Consatenate functio
but that doesn't work b/c it returns it as text and that doesn't work
i need it has data. What I'm trying to do is if cell B1 is equal t
either (names are irrelavent) Apple, Banana, Cherry, Date, Eggplant an
so on for up to 20+ names then it will pull data from a certai
column(s) in a certain worksheet. Each one has 3 worksheet
corresponding to it, so for Apple, it has 3 different worksheets tha
correspond with it, each has a different function. So what I want t
do is something like this (without the limitation):

=if($b$1="Apple",if('applesub'!A1>0,'applesub'A1,if($b$1="Banana"
if('bananasub'!A1>0,'bananasub'A1,.... and so on.

Now to make things easy I have 4 main worksheets that pull the dat
from the other worksheets to make it easier for formulas. The data i
these 4 main worksheets will change when I enter Apple vs Banana i
cell B1. I have tried a lookup function but i don't know how to mak
the vlookup function look at more than just one worksheet. Like if i
was Apple then lookup values on AppleSub worksheet, if it banana the
lookup values on BananaSub worksheet. The main page is my "results
page. If everyone is now even more confused then when they starte
reading then join the crowd and i'll try to explain more.

Thanks
 
Hi!
If everyone is now even more confused then when they started
reading then join the crowd and i'll try to explain more.
Click to expand...

Hmmm.....

It's not real clear what you're trying to do but I did read something about
you trying a lookup.....

Maybe something along these lines:

=VLOOKUP(C1,INDIRECT(B1&"sub!A1:B5"),2,0)

???

Biff

"bigwilly11189" <[email protected]>
wrote in message
 
Alright I'll try to explain a little more. When you enter Say "Charter
into Cell B2 on the results worksheet, all the accounts that are i
"Charter" show up in a vertical list, where each account is in its ow
cell, these accounts are all listed on another worksheet. At the sam
time all the cashflows with dates appear on the Cashflow workshee
where on the "Cashflow" worksheet account number one will be in A3
then Cashflow 1 amount will be in B3, the date of Cashflow 1 will be i
cell C3, then Cashflow 2 will be in D3 and the Date in E3 and so on.
If you can tell me how to tell excel that when say "Charter" is entere
into Cell B2 on the "Results" worksheet, it automatically looks for
certain worksheet to pull the data from for 3 other worksheets. But i
I entere say Comcast in cell B2 it will pull the data from a different
worksheets. This is why the IF statements work so well, b/c I can sa
If B2 equals this, then pull the data from this worksheet, if not the
if it equals anotehr name then pull the data from another worksheet an
so on. I tried the consatenate (sp??) function which would work if
could somehow get it not to be as a text. I need the Cashflows as $'
and the Dates as Dates and not text which they come out as when I us
that function. I hope this clarified things a little
 
anyone??? What I want to be able to do is Cell B1 on the main workshee
has a drop down list, when you pick something in that list, it pull
information from the worksheets that correspond with that word o
phrase and puts the information on a different worksheet. Can this b
done? The information is Data and not text. Can I do a VBA function
 
Back
Top