-
You are in the middle of asking a question
-
Back to my question
-
No thanks I'm done
Trying to use a dynamic reference for an excel table array
-
Here's my problem. I have a large excel table where at any given time only a few of the rows are tagged for use (Column A is "Y" or "N"). I am trying to figure out how to create a function/equation that looks down column A and returns all the rows that have a Y in column A.
I have been trying to use a vlookup function where the table array is being dynamically generated in another cell. For example: let's say that vlookup function is in column D and in in column E I am generating table arrays (i.e. g4:k16). I want my vlookup to reference Column E to get the appropriate table array.
I am open to any suggestions. Thanks
John
Posted Answers
No answers were posted yet - be the first one to answer!
Sign in to participate
Got an answer for jnkrs? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
How to do the quastion like this? /* Class MyCafe */ public class MyCafe { // MyCafe Attributes/Variables : String staffId ...
Submitted by
sally
1 year ago.
-
0 answers
- viewed 80 times
How do I convert a javascript byte array to a java byte array?? Basically I am calling a javascript method that returns me a ...
Submitted by
Jumbu
1 year ago.
-
0 answers
- viewed 2576 times
I have an array (does not matter the content). I want to know how many sub arrays there are? A sub array is a sequence (not broken ...
