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