returning vlookup values for blank cells

  • Thread starter Thread starter Craig McCormick
  • Start date Start date
C

Craig McCormick

I have a spreadsheet that lists "soccer players" by name
down the first colunm and "time in game" across the top
and the position they play in array.

I then use vlookup for another spreedsheet by "position"
down the first column, time across the top and puts the
players name into the positions. All this works fine.

Since there are 5 more kids than positions, the orginal
spreedsheet has blanks when the kids are out of the game.

How do I use vlookup or other to extract the 5 sub'd out
kids at the bottom of the 2nd spreadsheet? It only
returns the name associated with the 1st blank.
 
Craig McCormick said:
I have a spreadsheet that lists "soccer players" by name
down the first colunm and "time in game" across the top
and the position they play in array.

I then use vlookup for another spreedsheet by "position"
down the first column, time across the top and puts the
players name into the positions. All this works fine.

Since there are 5 more kids than positions, the orginal
spreedsheet has blanks when the kids are out of the game.

How do I use vlookup or other to extract the 5 sub'd out
kids at the bottom of the 2nd spreadsheet? It only
returns the name associated with the 1st blank.
Click to expand...

Take a look here, under Arbitrary Lookups:
http://www.cpearson.com/excel/lookups.htm
 
Use 1,2,3 or more spaces instead of blanks - VLOOKUP() will find them correctly.

Regards
BrianB
 
Thanks for both inputs. Both work.

Paul, yours was what I needed. Worked perfectly.

Thanks...Craig
 
Back
Top