Multiple VLOOKUP lookup values

[SkyTheImmense]

Hello.

I'm new to VLOOKUP and I may have bitten off more than I can chew. I
have a table of data in one sheet labelled by week number (1-52), and
broken up further in to days (so each week has 7 rows, Mon - Sun). On my
main sheet I have a grid of each day of the week with three columns of
data. The vlookup needs to fetch the data based on the week number
entered by the user, and then present data individually for all 7 days
in all three columns.

Obviously I can only use one lookup value at once, the week number, so
how do I instruct the sheet to show Monday's data in Monday's row and
Tuesday's in Tuesday etc.

It's either going to be a really simple solution and I'm going to hate
myself, or it'll be an impossibility and I'm going to want to kill
myself.

Screenshots can be provided if I haven't explained myself terribly
well.

Cheers,
Sky.




--
SkyTheImmense

[lhki...@comcast.net]

Do the screen shot or post a link to an example sheet.

Regards,
Howard