Try Again,If,Workday,Vlookup,or Cannot be done!
Posted by L.E. Patton on December 26, 2001 5:27 AM
John gave an answer, but I dont think my example was understood so I will sling it out diffrently.
My Workbook has sheets named for each day of the week.Each day contains values from prev. week (A=prod#, B=value allways). Worksheet named "Production Sheet" has product # and a col. for next day last week (in cell G1)If today was Monday G1 would =Tuesday
What formula would look at cell G1, go to same daily sheet(Tuesday) find a product no# A1:A200, return the value from B1:B200
Sorry I hope this explains more
Posted by Gary Bailey on December 26, 2001 6:39 AM
If G1 has "Tuesday" in it and you want to look on the sheet named Tuesday then
=VLOOKUP(product_no_to_lookup,INDIRECT(g1&"!A1:B200",2)
Gary
Posted by L.E. Patton on December 26, 2001 8:36 AM
Thanks Gary but it says it is missing an argument!
I tried this =VLOOKUP(A3,INDIRECT(g1&"!A1:B200",2) Gary : John gave an answer, but I dont think my example was understood so I will sling it out diffrently.
Posted by Juan Pablo G. on December 26, 2001 12:46 PM
Missing a parenthesis
=VLOOKUP($A3,INDIRECT($G$1&"!$A$1:$B$200"),2)
Juan Pablo G. Thanks Gary but it says it is missing an argument!
