How would your Vlookup suggestion choose *which semester* of "Manny" to
return?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Mike Anas" wrote in message
...
I recommend using the VLOOKUP worksheet function. If spreadsheet 1
occupied the range A1:C9 of sheet1, then you could place the following
formula in spreadsheet 2.

=VLOOKUP("Manny",sheet1!A1:C9,3,false)

If "Manny", is in cell A1, it would read:

=VLOOKUP(A1,sheet1!A1:C9,3,false)

The third parameter, the 3 above, indicates which column to pull the
data from when the name is matched. The false parameter indicates an
exact match must be found. In plain English, this formula is saying,
find the value in cell A1 in the first column of the range A1:C9 on
sheet1. When there is a match, and only an exact match, pull the value
from column 3 of the same row in that range.

Mike Anas
http://mikeanas.googlepages.com/