Using lookup function to retrieve columns of info

Hey guys. I'm new here and need a little help. I'm trying to use the lookup function to find a value out of a list in one column then show the value from another column and that row. Here's an example:

Day1. Day2. Day3
Jon. T1. T3. T2.
Mike. T2. T1. T3
Jane. T3. T2. T1

I need to show who has t1, t2, and t3 on another spreadsheet as a calendar. Ex:

Day1. Day2. Day3
T1. Jon. Mike. Jane
T2. Mike. Jane. Jon
T3. Jane. Jon. Mike

I'm using =lookup("t1",B:B,A:A) and also tried =lookup("T1",B2:B4,A2:A4) but it always shows the wrong result or I get the first day to work but the following days don't. Eventually I need it to work using 30+ names, 15 different "Tx" variables, and over 6 days.

I'm not even sure if this is possible. I appreciate any help you could give me. I've been plugging at this for 2 days and I think I'm starting to see letters and numbers in my sleep.

Lookup functions work from left to right so the lookup value has to be in the left most column, you would need to use an Index match function to extract the data from the current format. It's more complicate to understand. Search " Excel Index Match on YouTube and you will find some great videos that explain how it works.

Is the attached what you are after?

Stephen

That looks exactly like what I'm looking for Stephen. Thank you. I only have my iPhone right now so I can't see the formulas you used. I'll look at it this afternoon when I get back to my office.

Tank997, I'll look into that. I'll spend most of my afternoon watching YouTube. Thank you!

Hi there,

Please have a look on the attached template that will have the formula that you need.

Basically you the formula has VLOOKUP and CHOOSE so it can check the numbers that are on the left.

Have a look and please let me know if that works for you.

Other thing that will not work on that formula is if more than one person have T1;T2 or T3 on the same day.

Cheers,
Filipe Oliveira.

We can give you the answers but if you don't understand how or why they work you're not going to learn much

Once I can see the formulas I'll be able to understand what input it's looking for. These YouTube videos are helpful, but haven't found one that ties them together like this. I just haven't found the right video yet. I am dedicated to figuring out how it works.

You guys are awesome! I got it to work using the index and match and I'm plugging it in now with no issues. I appreciate the help! Thanks