returning a text value
in [Functions]
|
Prev: how do i insert todays date in a spread sheet just prior to print
Next: RANDBETWEEN generating numbers outside range
From: Tim on 25 May 2010 14:19 I think this is simple but I am confused with it. I am creating a softball roster. Column a is the positions, Column b is player for inning 1. C is inning 2 and so on. So with my current grid I can see who is in which position by inning. My second grid will show players name followed by position being played. Column F lists all the players. I need a function that will search column b for matches to column F and insert the position (column a) in column G.
From: Fred Smith on 25 May 2010 15:23
Check Help for Vlookup. Regards, Fred "Tim" <Tim(a)discussions.microsoft.com> wrote in message news:13344C20-6A5C-43DD-9D6E-BEF65D053A82(a)microsoft.com... >I think this is simple but I am confused with it. I am creating a softball > roster. Column a is the positions, Column b is player for inning 1. C is > inning 2 and so on. So with my current grid I can see who is in which > position by inning. My second grid will show players name followed by > position being played. Column F lists all the players. I need a function > that > will search column b for matches to column F and insert the position > (column > a) in column G. |