Use the named sheets to match

[angela.fitt]

I would like to use a vlookup formula using the named sheets in a workbook. One sheet has the same list of names as the worksheet to create a named range. From this sheet I will then use the information in the adjacent column to populate the cell on the named sheet that matches. I have attached an example.

[alansidman]

In cell G9, type this formula

=VLOOKUP(MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,1024),EmployeeInfo!A1:B2,2,0)