VLookup Help, driving me nuts

[Sillybirds]

Hi all

I am sure this is probably the simplest thing for a lot of you, but am very new to this formula, and its driving me nuts lol.

I have two spreadsheets, completely separate, I have to download one from a different computer system, and put into excel etc, and this is the location list.

I need my spreadsheet to read from the location list so that I know when people are still within our establishment etc, so have been trying to do a vlookup so that it reads from unique identifiers ie NOMS number and I need it to read the location list and bring back a cell number from location on that sheet?

Is this possible because my location list has extra columns in that have been merged, which I cannot take out, as otherwise every single day when I create the location list from the other computer system, I will need to open it up and delete the extra merged columns etc - so when I am trying to fill out the Vlookup formula it is just not working!!!

I have enclosed hopefully the sheets I am using, and in the top sheet which is the blank location list, I need to pull the info I need from Location etc - anyone able to help?

Example.docx[ATTACH]

[sandy666]

....................

Done