Unless you use a separator.
For this type of concatenation I always include the pipe character |

=A1&"|"&B1

abcd|efgh

--

Regards
Roger Govier

"Ragdyer" wrote in message
...
One of the problems using concatenation with these types of lookups is:

abcd & efgh
AND
abc & defgh

Will incorrectly be returned as a match.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike Anas" wrote in message
...
On Dec 15, 10:41 am, "RagDyeR" wrote:
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 Anashttp://mikeanas.googlepages.com/

RD- you are right to point that out, that's why I pulled my post. I
didn't catch that this was a 2-field lookup. Normally, I handle these
types of situations by creating an extra field that concatenates the
two, and then do a VLOOKUP on that.

Mike