Comparing Text Fields and returning a cell value on a match.

[MannyG13]

I have a data dump that has 2 fields FULL NAME and SHORT NAME. I hav
a seperate data dump with a field called LOGIN NAME.

EX: FULL NAME = James Williamson
SHORT NAME = JWilliamson
LOGIN NAME = JWilliam

There are more FULL\SHORT NAMES than LOGIN NAMES.

I dump each into a column (A, B, C)

I'd like to extract FULL NAME when LOGIN NAME = the 1st characters o
SHORT NAME

 

[Cutter]

In Col D

=IF(C13=LEFT(B13,LEN(C13)),A13,""

 

[MannyG13]

Thank you for your reply, but this only works if all the data is on th
same row.

In your example;

data in A13,B13 and C13

In D13 put this

=IF(C13=LEFT(B13,LEN(C13)),A13,"")

But LOGIN NAME = JWilliam may be in C13 but
SHORT NAME = JWilliamson may be in cell B11 and the
FULL NAM

 

[MannyG13]

Thank you for your reply, but this only works if all the data is on the
same row.

In your example;

data in A13,B13 and C13

In D13 put this

=IF(C13=LEFT(B13,LEN(C13)),A13,"")

But LOGIN NAME = JWilliam may be in C13 but
SHORT NAME = JWilliamson may be in cell B11 and the
FULL NAME = James Williamson will always be one column left of SHORT
NAME.

Your formula does not return a value when it's not in the same row.

This is the formula (modified to check a range) I used

=IF(C2=LEFT($B$2:$B$14,LEN(C2)),$A$2:$A$14,"")

and it works if the matching data is in the same row, but if it's not I
get a blank cell.

Anybody know how to check for this?