Hi Guys
A member of staff resigned and gave only a weeks notice, I have been given her reporting to do, In the report this formula has been used
=VLOOKUP(A2,'[All emploiyee reports 11 Nov.xlsx]Sheet1'!$A:$E,5,0)
What is it referring to?
I understand that it is referring back to another spreadsheet and its sheet one but I have never used V Lookup before so a breakdown of what it is doing would be awesome.
Thanks
Bookmarks