choose table_array in VLOOKUP from list of multiple worksheets?
In Excel 2003, I could define the Table_Array argument for the VLOOKUP function by selecting a second workbook after the VLOOKUP argument pull down was activated. I am unable to repeat this with Excel 2007. anybody know a
I am wondering is it possible to use a variable value for the table_array input on a counterargument.
So for instance the vlookup argument is
=vlookup(lookup_value, table_array, col_index_num, [range_lookup])
and I would like to have one of several arrays used depending what is selected in a drop down box.
Can this be done or could someone suggest a different way of doing it.
I am working on a lookup formula and having trouble. I am trying to link the table_array portion of the vlookup to the selection made in a drop down box. Think of it this way.I have 50 tables set up, one for each state, if a person selects the state of Ohio from the list the table array will now have the name of Ohio seas only in that table.
=vlookup(sales tax,result from drop down box, 2)
if I type in =vlookup(sales tax, Ohio,2) I get the results I need.
I have a single (large) workbook, with multiple worksheets (all same layout and format).
These multiple sheets show data being returned from multiple sources. I have to cross-check another sheet of unique reference numbers to see if they exist in any of the multiple sheets.
I've been using the VLOOKUP function with success, but to do this I have been consolidating (Using cut & paste) the multiple sheets into one. The multiples are getting larger and larger (over 15 sheets) now. Is there a way of searching for a cells contents (lookup_value) across multiple data sources (Table_array across multiple sheets) and returning a result (or even a #N/A - at least I'd know if the unique ref exists!).
If there's another function other than VLOOKUP then I'm happy to adapt!
I am using a drop down menu in A1 to reference 28 different table "ranges" that I've named (end entered data into) on another sheet.
In A2, I use a dropdown menu to select the Row I will be VLOOKUP(ing) from the table range I selected in A1.
In A3, I would like to the use VLOOKUP and have it read the Text for the range name I've selected in A1, and enter that into the table_array position.
How do I have it "read" text and insert that variable text into the table_array position?
Does my question even make sense?
Related Applications & Scripts
The ComboBox can be configured to allow selection of multiple options, but in this case a list of options with CheckBox is much more intuitive for users.
CodePeople List transform ComboBox with multiple selection into a CheckBox list, and also to allow the incorporation of new options that are not part of the initial listing.
When your visitor sends an email to the autoresponder or fills up a subscribe HTML form, the script will automatically send out a reply, add the sender to the mailing list and followup will begin at predetermined intervals. You can easily manage the mailing list entries using the mailing list manager. Features include: multiple autoresponders, multiple mailing lists, multiple domains, personalized followup messages, scheduled mailings, email duplication check, unlimited custom fields, multiple file attachments, powerful mySQL database (tested with 1 million subscribers), easy-to-use interface, no monthly fee, plus much more. Easy to setup perl cgi scripts available for free download.
Facebook "Choose between friends" is a funny and highly entertaining facebook app that asks a user a question like: "who have the best haircut?" and the user is shown pictures of two friends and has to choose between the two.
This script has a very high potential to go viral and be widely spread very fast, you just have to start using it. Do you dream about having a successful Facebook app? This is your chance.
Simple Tweeter allows you to list multiple twitter accounts on a single page on your site. This is beneficial for listing employees or people you find the most helpful on twitter.com. Simple Tweeter also allows you to group accounts under tabs. All of this is done really easily from the Admin Panel, so no coding knowledge is required at all!
- Feature multiple Twitter Accounts on one Page
- Group Accounts under Tabs
- Easy to use Database Installation Program
- Easy to use Admin Area, so no programming required!
- Valid XHTML 1 .0 Transitional and CSS 2 .1
- Works in all Major Browsers!
SFESurvey will allow you to create multiple-choice quizzes or surveys online with a twist. Rather than having one correct answer, and multiple incorrect distractors, each possible answer is weighted or assigned a certain number of points. The instructor/test creator can then assign various comments or scores to different ranges of raw scores.
The quiz taker's score and any additional fields you choose (Name, Age, Gender, Occupation, Favorite Color -- whatever you like) are saved to a score database, but there is currently no option to view scores or score statistics