ExcelBanter - Multiple VLOOKUP lookup values

On Sunday, May 12, 2013 3:33:11 PM UTC-7, SkyTheImmense wrote:
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

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

Regards,
Howard