D Dave Peterson Jul 23, 2007 #3 Maybe something like this... With the worksheet name in A1 of the worksheet with the formula: =vlookup(a2,"'" & $a$1 & "'!a:e",5,false)
Maybe something like this... With the worksheet name in A1 of the worksheet with the formula: =vlookup(a2,"'" & $a$1 & "'!a:e",5,false)
D Dave Peterson Jul 23, 2007 #4 Oops! I had a typo: =vlookup(a2,indirect("'" & $a$1 & "'!a:e"),5,false)
