Solved: Two Vlookup's in one cell

[Emoncada]

Is it possible to have 2 vlookups in one cell?

I need to do this.

I have 2 sheets.

Sheet 1 has column B and column C with NFL Team schedule.


Column A = Dates
Column B = Away Team
Column C = Home Team


Sheet 2 has
Column A from row 2:33 all the Team Names
Column B from row 2:33 all the Team Helmets.
So example

Column A.....................Column B.........Column C.............Column D.....
Team Name...............Team Helmet........Sept. 4...............Sept 7.......
San Francisco 49ers.....Helmet pic.........** ????? **......** ????**......
Chicago Bears.............Helmet pic.........** ????? **......** ????**......
etc......


How can I have it do some type of search or vlookup in Sheet2.
To look up Column A in Sheet1 and return the team they are playing.

[Mavyak]

Can you post a sample workbook?

[Krishna Kumar]

Hi,

In E2 through F2 on Sheet1 and copied down,

=$A2&"#"&B2


In C2 on Sheet3 and copied down & across,

=IF(ISNUMBER(MATCH(C$1&"#"&$A2,Sheet1!$E$2:$E$10,0)),INDEX(Sheet1!$C$2:$C$1 0,MATCH(C$1&"#"&$A2,Sheet1!$E$2:$E$10,0)),IF(ISNUMBER(MATCH(C$1&"#"&$A2,She et1!$F$2:$F$10,0)),INDEX(Sheet1!$B$2:$B$10,MATCH(C$1&"#"&$A2,Sheet1!$F$2:$F $10,0)),""))

Adjust the range.

HTH

[Emoncada]

That seemed to work Krishna THanks.