Import New Field - Based on First & Last Name

[Matthew_12345]

Hi All,

I havent ever tried to achieve the following;

What i have is a complete list of Employess and license details but i need to import another field from another spreadsheet and the only thing that will work is based on their names.

First and Last.

Is this first of all possible?

i will upload some examples if this helps

Kind Regards

Matt

[jhren]

Yes it is possible.

Examples will make the process easier.

Anticipatory question... when the field is bought in, do you want it to remain linked to the source (i.e. dynamic) or not (i.e. static)?

[Matthew_12345]

Ok i have attached

2 x Spreadsheets

1) Mastersheet will contain a list of licenses for employees with the extra field at the end "Called Data"
2) Extra Sheet Containing the extra data field "Called Data" ExtraSheet.xlsxMasterSheet.xlsx

[Matthew_12345]

when the field is bought in, do you want it to remain linked to the source (i.e. dynamic) or not (i.e. static)?[/QUOTE]

sorry missed replying to this - if it can be permantley stored in the "master Sheet" that would be better

[FDibbins]

Would there be a problem to add a helper column to the "Extra" W/B...or change the order of the columns?

If we can do that, then a relatively simple index/match from MASTER into EXTRA will give you what you want.

add a helper....In EXTRA C2, copied down =A2
OR move column A to after the names

then in MASTER, L2, copied down, use this ARRAY formula...
=INDEX('[ExtraSheet(1).xlsx]Sheet1'!$D$2:$D$20,MATCH(B2&C2,'[ExtraSheet(1).xlsx]Sheet1'!$C$2:$C$20&'[ExtraSheet(1).xlsx]Sheet1'!$B$2:$B$200,0),1)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.