Is there any way to do the same as SUMIF that will output the text of a cell?
(SUMIF only outputs values)
Basically two spreadsheets each with a similar list of names in one column
and in the second column some info. the two sheets need to be merged into one
with both sets of info next to the list of names.
(Of course some of the names in each do not match as sheets were set up by
different people at different times etc etc) about 80% will match though)
many Thanks