| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup?
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 Wrote: 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? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup?
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? "Simon Lloyd" wrote: 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 Wrote: 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? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup?
That doesn't help wee need more details on what you want to do and how! Confused;429444 Wrote: 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? "Simon Lloyd" wrote: 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 Wrote: 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? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage - Microsoft Office Help - Microsoft Office Discussion' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Vlookup? - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=119295) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup?
Can I email you the file so that you can see what I am trying to do?
"Simon Lloyd" wrote: That doesn't help wee need more details on what you want to do and how! Confused;429444 Wrote: 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? "Simon Lloyd" wrote: 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 Wrote: 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? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage - Microsoft Office Help - Microsoft Office Discussion' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Vlookup? - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=119295) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup?
For further help with it why not join our forums (shown in the link below) it's completely free, if you do join you will have the opportunity to add attachments to your posts so you can add workbooks to better illustrate your problems and get help directly with them. Also if you do join please post in this thread (link found below) so that people who have been following or helping with this query can continue to do so. :) Confused;431608 Wrote: Can I email you the file so that you can see what I am trying to do? "Simon Lloyd" wrote: That doesn't help wee need more details on what you want to do and how! Confused;429444 Wrote: 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? "Simon Lloyd" wrote: 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 Wrote: 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? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage - Microsoft Office Help - Microsoft Office Discussion' ('http://www.thecodecage.com' (http://www.thecodecage.com/))) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' ('The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)) View this thread: 'Vlookup? - The Code Cage Forums' ('Vlookup? - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh....php?t=119295)) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('http://www.thecodecage.com' (http://www.thecodecage.com/)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Vlookup? - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=119295) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
