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.
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.