PDA

View Full Version : Solved: Two Vlookup's in one cell



Emoncada
08-28-2008, 07:55 PM
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
08-28-2008, 08:31 PM
Can you post a sample workbook?

Krishna Kumar
08-29-2008, 02:41 AM
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$10,MATCH(C$1&"#"&$A2,Sheet1!$E$2:$E$10,0)),IF(ISNUMBER(MATCH(C$1&"#"&$A2,Sheet1!$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
08-29-2008, 06:07 AM
That seemed to work Krishna THanks.