Archivis
Your Daddy
Premium
join:2001-11-26
Earth
 ·Verizon FIOS
| reply to Dezbend
Re: [OT] excel help
So you need to put a value (Cell C), into Cell A, only if it meets the criteria in Cell B?
That's called an Array Formula. You don't need VBA for that. Excel supports this.
But yeah, you definitely need to be "retrieving" instead of "pushing" data. Dez, hit me up in PM's. If I don't know how to do it in excel, it can't be done, or you need to be a programmer.
--
'A government big enough to give you everything you want, is strong enough to take everything you have.' -Thomas Jefferson -
|
|
avd706
insert annoying animated gif here
Premium
join:2003-02-06
Union, NJ | mysql FTW |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs: | reply to Archivis
The issue is that there are two sheets and the rows aren't equivalent. |
|
Dezbend
Premium,MVM
join:2001-04-20
| said by drew  :The issue is that there are two sheets and the rows aren't equivalent. QFT
don't worry about it guys. If it isn't easy, it isn't worth it. This isn't a job requirement, it was a "hey this would be nice" kind of thing. It is easy enough for me to say Excel can't do it.
--
DSLr Mafia Member. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA
| looking at it again, I think you can use vlookup. see the attached. |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs: | Sheet 1 won't always have the same names as Sheet 2. I don't think this is something they wanted to do "manually" |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA
| said by Dezbend :The list of names on sheet 2 may change from day to day… I took this to mean that sheet 1 won't change, but the data in sheet 2 will. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | also, right now if the name from sheet 1 isn't in sheet 2, you'll get the nasty #N/A error. you can is ISNA() and IF() to change these errors to meaningful messages. |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to bjl
correct.
the vlookup function may be what I need. when I get a chance today, I will look at this function and play around with it a little.
Thanks for pointing me in that direction bjl. I will let you know.
--
DSLr Mafia Member. |
|
Dezbend
Premium,MVM
join:2001-04-20 | reply to Dezbend
vlookup works for what I need. Thanks bjl! |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | no problem! |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to bjl
said by bjl :also, right now if the name from sheet 1 isn't in sheet 2, you'll get the nasty #N/A error. you can is ISNA() and IF() to change these errors to meaningful messages. can you explain this a little more for me?
I do have a bunch of #n/a I need to clean up... I want it to result a "0" if there is no name found.
--
DSLr Mafia Member. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA
| said by Dezbend :said by bjl :also, right now if the name from sheet 1 isn't in sheet 2, you'll get the nasty #N/A error. you can is ISNA() and IF() to change these errors to meaningful messages. can you explain this a little more for me? I do have a bunch of #n/a I need to clean up... I want it to result a "0" if there is no name found. you need to wrap the vlookup functions with IF(ISNA()), e.g:
=IF(ISNA(vlookup statement),0,vlookup statement)
--
flickr gallery | photo blog (rarely updated) | play mafia! |
|
Dezbend
Premium,MVM
join:2001-04-20 | ok thanks. |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to Dezbend
one last question.... and thanks for all the help.... is there a way to turn auto sorting on? (so when he drops the raw numbers into sheet 2 it will update the numbers with the functions bjl provided me, it will then sort sheet 1 by a certain column value(i have a total column that adds up the sales)?
--
DSLr Mafia Member. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | you could probably create a macro and add a button to run it. |
|
Dezbend
Premium,MVM
join:2001-04-20 | I have a macro, how do I make a button? |
|
Dezbend
Premium,MVM
join:2001-04-20 | never mind... I am following the instructions in help. |
|
