Multiple Search Criteria/ Index Match
I am using the following formula to retrieve data that matches tw
using ctrl,shift, enter to give curly brackets to make it work.
This formula is then repeated in the cell directly below, but searche
for "February", below that "March" and so on.
However when I copy my formula, I have to change the month for eac
cell and therefore have to put in the curly brackets again.
Is there anyway around this
Message posted from http://www.ExcelForum.com
Have a list with the ...using a date in vlookup
i want to perform a vlookup using the Now() function to generate the
lookup value (A1), the 1st column in the table [col B] array will be
all the dates in a year listed consequtive,, and the 2nd column being
a value assigned to each day in the 1st column [B]. My formula is
vlookup(A1,B1:C367,2). The result I get is "#N/A. What am i doing
NOW() returns both the date and the time, so you would be better off
using TODAY(), which only returns the date.
Another problem might be that your dates in column B are really text
values that just look like dates - see what happe...vlookup excel and access...
assuming i have this code, is possible to use this vlookup withnthe
adta into mdb access?...
Private Sub TextBox25_Change()
Dim CODICE As Integer
Select Case Me.TextBox25
Me.TextBox4 = ""
Case 1 To 8
CODICE = Val(Me.TextBox25)
Me.TextBox4 = Application.WorksheetFunction.VLookup _
(CODICE, Worksheets("TABELLA").Range("Q2:R9"), 2, False)
Inested column Q and R in excel i have created a mdb into:
and into this mdb have inserte a table U...Multiple charts in ChartSpace; problems with double Categories
I want to show two or more charts with different categories and data in
one chartspace, so I did the following:
1. Create Chartspace
2. Add Chart1 in Chartspace
3. Add Series in Chart1
4. Series.SetData chDimCategories 'A,B,C'
5. Series.SetData chDimValues '5,2,6'
Now I see a chart with categories A (value=5), B (value=2) and C
(value=6). So everything okay. Next thing I do:
6. Add Chart2 in Chartspace
Now I see a second empty chart, BUT WITH already filled categories A,B
and C!! I don't want this, because I want to use other categories in
this second chart2.
And whe...Vlookup within a vlookup
I am trying to lookup a cell within a table - but the table to use is found
in another table.
Cell B2 is a dropdown box allowing one of the choices in colum f below.
Column G represents which table to use for the initial lookup based on your
choice in the drop down dox.
column f column g
Alt A 30 Yr fixed30
Alt A 15 Yr fixed15
All I get is an error - can someone help ?
It sounds like you would need to use INDIRECT within the lookup formula
that thread shows the way to do it exce...Turn off auto adjust of row heights
I have a complex spreadsheet for my catalogue of products. I have set row
heights, fonts and sizes of texts for different rows. Every now and then my
row heights are automatically changed by EXCEL. I have turned off word wrap
I have locked/protected my sheet. How can I stop EXCEL automatically
readjusting row heights at its discretion.
...Lost on Vlookup, match, etc....
Can someone walk me through this please?
I a workbook that imports a years worth of data from filemaker to be
analyzed and charted in excel.
It contains several sheets, but I am concerned with worksheet 1 (daily
data) and worksheet 2 (bodyweight). Daily data contains the raw data I
pull in from Filemaker. It results in a table with a row for each day
of the year. It has 12 columns, but in this instance, I am only
interested in 2 of the colums Column F, (Date), and Column R
(Bodyweight). There is only one entry per week for body weight.
The bodyweight sheet has 3 columns (week #, date, and w...How do I link one person to another in the same table?
I have a table of Contacts. Some of my contacts know other contacts, and I
would like to indicate that in their record. However, for Data Type, I
cannot create a drop down list of contacts from within the table to choose
Any idea how to to this? Or, if this is not possible, can you suggest
another way to indicate "who knows whom"?
Your contact table ought to look like:
Then you need am acquaintenances table:
ContactID (identifies a Contact)
AcquaintedContactID (Ident...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
I have 500+ rows of data that I would like to insert a
blank row in between each row. Is there a globabl way of
doing it rather than having to click on each row one at a
time and then selecting 'insert row'?
have a look at
> I have 500+ rows of data that I would like to insert a
> blank row in between each row. Is there a globabl way of
> doing it rather than having to click on each row one at a
> time and then selecting 'insert row'?
Thanks...Forwarding Multiple Emails to AOL
I have about 2,400 email messages saved on Outlook that I need to transfer to
an AOL Email account. How can I do this without emailing each individually?
"awerhun" <email@example.com> wrote in message
>I have about 2,400 email messages saved on Outlook that I need to transfer to
> an AOL Email account. How can I do this without emailing each individually?
Simply create your AOL account in Outlook, then drag the messages to the AOL
Brian Tillman [MVP-Outlook]
O...Create Multiple Index
I want to build a multiple index on a table in my database. Can anyone tell
me why this does not work?
Private Sub Command0_Click()
DoCmd.RunSQL "CREATE INDEX Models ON tblCatalogModels, (Year, Make, Model)"
"NEWER USER" <NEWERUSER@discussions.microsoft.com> wrote in message
> Access 2007
> I want to build a multiple index on a table in my database. Can anyone
> me why this does not work?
> Private Sub Command0_Click()
> DoCmd.Ru...Making 2 colums into one
I have an excel file that I imported into Access. There are 5 fields.
The item names are in column 1 and column 3. I need to combine the two
columns in to just one column. Can this be done?
Thanks for your help and reply.
Message posted via AccessMonster.com
Use a calculated field --
Combined: [column 1] & " - " & [column 3]
Or omit the dash and use one space or comma and a space as you wish it to be
You could add a new field in your table and run an...VLOOKUP problem
I down a list of top 100 stock symbols to Excel and place them in Column
A and their rank in Column B (1-100). the next week I download a new
list of the top 100 stock symbols and their rank to Column C and D
respectively. then I create column E using the function
=VLOOKUP(C4,A:B,2,FALSE) Which tels me the rank each stock had last week
and if a stock is new this week it puts "#N/A" in the appropriate
cell in column E. How do I get the Vlookup function to put "NEW" in
column E if the is new to the list and wasn't in the list last week?
=if(isn...Index Match Functions #2
Has anyone ever combined the Index and Match functions to do lookups?
UnumProvident User wrote:
> Has anyone ever combined the Index and Match functions to do lookups?
...multiple item select from a combo box
I want to use this as a navigational tool, rather than to "input" values into
This control will be on a form that sets parameters for graphical chart
One of the requirements is to be able to select multiple values from a 2nd
combo box after a 'parent' 1st combo box determines what should be in the 2nd
I have a couple of ideas of how to do this, but was just wondering if
someone has already tackled something like this before.
I suppose I could populate a temporary table that has yes/no values in it
and display that in a subform (which scroll...VLOOKUP #40
Would like to post data from one worksheet to another.
Could you provide a few more details about what exactly you want
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"dr" <firstname.lastname@example.org> wrote in message
> Would like to post data from one worksheet to another.
...Publisher 2000-XP multiple pages not visible
I am new to this group seeking some help.
I was working on a large number of pages that I had scanned images onto
and entered text. In one document, I can see the first page only and
not the other 6. When I print, it prints out the pages correctly, but
I cannot view these pages, and needless to say, make any corrections.
My other documents, which have 100 pages in them, show nothing at all.
They also print.
When I made a new document to see what was going on, I can Insert new
pages, and nothing shows up on the bottom of the screen to show the
In My Documents, the file sizes ind...combobox and vlookups?
I am trying to add a combobox that when you select from the dropdown menu,
the columns nextdoor automatically pull up corresponding data that is related
to the selection from the dropdown list. Does this make sense? What do I do
to set this whole thing up? (I don't know code).
Message posted via http://www.officekb.com
You shouldn't need code for anything you described here. Set up the combobox
with the list fill range, if any. Set the linked cell to the desired cell.
Then, use the VLOOKUP command in another cell to look for the linked cell
from the combo box to lo...Combining multiple files into one work sheet
I have multiple files single worksheet files (30), each in it's own
directory that I would like to have combined into a single workbook. Each
file name is unique, however the midships of each file contains the date the
file was created "C:\XVG001\XVG001_20090713_Reviewed.xls".
Is there any way I can create a function or macro that will pull these files
from their respective directories and combine these sheets automatically into
Try this add-in
Regards Ron de Bruin
This is a multi-part message in MIME format.
I use the VLOOKUP function to pull basic data from external data sheets,
currently an example of my command looks like this:
=VLOOKUP($A5,'[RT NP 67 MF.xls]ODD'!$A$1:$S$250,$L$1,FALSE)
The "$AA%" is the data I am looking up and the "$L$1" is a variable to
the column I am wishing to insert.
The question I am trying to get an answer for concerns...how many pages can I have in one 2003 publisher file?
I am working with about 75 pages that combine text and photographs (inserted
from "My Pictures" files. How many pages will reasonable go into one
Publisher file? The next question, I want to page number. If I need to
divide my work into two documents, can I page number sequentially (i.e.,
start the second file with page 35)?
You can start your publication page numbers with any number by inserting a
section, then opening the Master page, insert page numbers.
A publication can be as lengthy as you wish as long your memory holds out. When
you start inserting large photos with...incorporate paste value in vlookup
is there a way to incorporate "paste value" in a vlookup formula ? I have the
vlookups in the column working and feeding off of the multiple worksheets.
the data will be updated weekly (and new columns with the updated data added)
and i would rather just copy new data on top of the old in the worksheets
instean of having to add new worksheets with new data... as to keep the
previous column from changing.
...Finding Data from Multiple sheets
I have a spreadsheet that contains the following:
Rows = Products
Columns = Months
Data = how many products sold in each month
This data is replicated on numerous sheets, each sheet is an individual
I need to look at the products sold over each month, for each customer and
identify - who sold the most per month? Ideally creating a list of the top
I have tried copy and pasting data from each sheet into one and used this as
a database to create a pivot table, but the whole process of copying and
pasting each clients data takes so long to do.
Any advice would b...delete a row
a macro which deletes a row if all the cells in that row from column
to column Z are empty
thanks a lo
Message posted from http://www.ExcelForum.com
> a macro which deletes a row if all the cells in that row from column
> to column Z are empty
> thanks a lot
> Message posted from http://www.ExcelForum.com/
hi frank , i need a smaller command not big macro...
thank u so muc
Message posted from http://www.ExcelForum.com