Hi,
I have text data on sheet1 (UserSort) in columns A and B - random order
cannot be changed
column B does not have text data in every cell, some are blank.
sheet two (Temp-A) column A has the same data as sheet1 column A. i need to
populate sheet2 column B with the data


sheet1 sheet2
A B A B
Hodge pc-hodge ralph ? (need to populate pc-hodge here)
ralph pc-ralph lacy (should be blank or #na if not data in
sheet1 column B)
jones jones
lacy smith
smith pc-lacy hodge

I have searched and adjusted these but with no luck:
IF(A9="",,"This is
true",INDEX(sheet1!$A$1:$A$1000,MATCH(TRUE,ISNUMBE R(SEARCH(A9,$B$1:$B$1000)),0)))

=INDEX(UserSort!$A$2:$A$1000,MATCH('Temp-A'!A1,$B$1:$B$1000,1))

=VLOOKUP(B4,UserSort!$B$2:$B$1000,1,TRUE)

Thanks for the help.