Hi
my data set is as follows:
spreadsheet 1 sheet 1 is the target and has the key we are looking for.
spreadsheet 2 sheet 1 & 2 is the source and contains different data but somewhere between the two sheets, it has the key in spreadsheet 1.
I would like to know how to find the key in either sheet and return the value of the field on the right from the source sheet into the target sheet.
Thanks in advance.
Regards
Ronnie
my data set is as follows:
spreadsheet 1 sheet 1 is the target and has the key we are looking for.
spreadsheet 2 sheet 1 & 2 is the source and contains different data but somewhere between the two sheets, it has the key in spreadsheet 1.
I would like to know how to find the key in either sheet and return the value of the field on the right from the source sheet into the target sheet.
Thanks in advance.
Regards
Ronnie