VLOOKUP using a cells value to reference another sheet

[Mighty Whites]

Hi,

How can I incorporate a cells value to determine which worksheet within the same workbook the vlookup is to reference?

For example the user can change which day of the week they wish to review and I want the vlookups to change which tab they reference depending on what day is selected.

e.g. =VLOOKUP(P16,Monday!E:G,2,FALSE)

Any help would be appreciated!

 

[njimack]

Assuming your day of the week cell is A1, try this:
=VLOOKUP(P16,INDIRECT(A1)&"!E:G"),2,FALSE)

 

[Mighty Whites]

Thanks,

The error message "You are entering too few arguments for this function" appears when I try to enter this formula....

Cheers for your help

 

[njimack]

Oops had a bracket in the wrong place. Try:
=VLOOKUP(P16,INDIRECT(A1&"!E:G"),2,FALSE)