Vlookup?

C

Confused

I am trying to create a summary table where when the user enters in a
criteria, the formula will look up the criteria, the year and name, and
return the value from another worksheet.

Criteria = A

Year1 Year 2 Year 3 etc
Name1
Name 2
Name 3
etc


Would I use the vlookup formula for something like this?
 
S

Simon Lloyd

Do you want the criteria to be a both the year and the name? is the year
a worksheet name? what value from what sheet are you wanting to return?
Confused;429328 said:
I am trying to create a summary table where when the user enters in a
criteria, the formula will look up the criteria, the year and name, and
return the value from another worksheet.

Criteria = A

Year1 Year 2 Year 3 etc
Name1
Name 2
Name 3
etc


Would I use the vlookup formula for something like this?
Click to expand...


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
C

Confused

I'm trying to create a table where if the user enters in a criteria, say "A",
the table would automatically populate with a $ based on information from
another worksheet.

The year 1, year 2 etc, and the name1, name 2 etc will never change. Only
the criteria will change.

Am I making any sense here?
 
S

Simon Lloyd

That doesn't help wee need more details on what you want to do and how

Confused;429444 said:
I'm trying to create a table where if the user enters in a criteria, sa
"A"
the table would automatically populate with a $ based on informatio
fro
another worksheet

The year 1, year 2 etc, and the name1, name 2 etc will never change
Onl
the criteria will change

Am I making any sense here




Office Discussion' (http://www.thecodecage.com)
Click to expand...

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
S

Simon Lloyd

For further help with it why not join our forums (shown in the lin
below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :)

Confused;431608 said:
Can I email you the file so that you can see what I am trying to do




Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
(http://www.thecodecage.com/forumz/showthread.php?t=119295
Click to expand...

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
C

confused

See attached for file. Here is an explanation of what I am trying t
do. In the "Amt by Year" tab, the user can select the criteria in cell
B3:B5 which contains a drop down list.
For example, the user selects Class = “A1”, Start Date = “5/28/09”, En
Date= “7/22/09”.

Given the three criterias above, I would like to populate the tabl
(see attached) using the “Data” tab information.

So in the table, cells A10:A17 are the names, and cells B8:AN8 are th
years, these will not change. I need excel to look up the Amount base
on the names and years that contains Class “A1”, “5/28/09” an
“7/22/09”, and populate the table accordingly.

I manually populated the table for you as to what the end result shoul
be.
Can a vlookup do something like this?

Thanks for your help
For further help with it why not join our forums (shown in the lin
below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :
Click to expand...

+-------------------------------------------------------------------
|Filename: Example.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=196
+-------------------------------------------------------------------
 
S

Simon Lloyd

Sorry but it doesn't seem to make sense, you have used the criteria that
you have explained but the section for 2009 is not populated?, what did
you populate manually for the given dates?

confused;432004 said:
See attached for file. Here is an explanation of what I am trying to do.
In the "Amt by Year" tab, the user can select the criteria in cells
B3:B5 which contains a drop down list.
For example, the user selects Class = “A1”, Start Date = “5/28/09”, End
Date= “7/22/09”.

Given the three criterias above, I would like to populate the table
(see attached) using the “Data” tab information.

So in the table, cells A10:A17 are the names, and cells B8:AN8 are the
years, these will not change. I need excel to look up the Amount based
on the names and years that contains Class “A1”, “5/28/09” and
“7/22/09”, and populate the table accordingly.

I manually populated the table for you as to what the end result should
be.
Can a vlookup do something like this?

Thanks for your help
Click to expand...


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
S

Simon Lloyd

Simon said:
Sorry but it doesn't seem to make sense, you have used the criteria tha
you have explained but the section for 2009 is not populated?, what di
you populate manually for the given dates
Click to expand...
In fact you have 33 values in your table but the criteria you want t
use would only produce 14 results

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
C

confused

I forgot to specify that I need to look up the minimum, maximum an
average for each name and year, so the "Data" sheet shows 14 results bu
since I am looking for the minimum, maximum and average for each nam
and year, it is 33. The reason why 2009 is not populated is because i
you filter the "Data" tab, by A1, and date, the column D "year" does no
show 2009. I populated manually the table in the "Amt by Year" tab.
 
S

Simon Lloyd

confused;432135 said:
I forgot to specify that I need to look up the minimum, maximum an
average for each name and year, so the "Data" sheet shows 14 results bu
since I am looking for the minimum, maximum and average for each nam
and year, it is 33. The reason why 2009 is not populated is because i
you filter the "Data" tab, by A1, and date, the column D "year" does no
show 2009. I populated manually the table in the "Amt by Year" tab.You're not going to manage what you want with formulae, it's going t
Click to expand...
have to be VBA, i won't have time to look at that right now, i will hav
a look tomorrow though

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
Top