MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!