Multiple VLOOKUP lookup values

[SkyTheImmense]

Hello.

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

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

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

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

Cheers,
Sky

 

[lhkittle]

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.

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

Regards,
Howard