Want to use VLOOKUP and IF for a code from another workbook

[dudeinaghillie]

So I have 2 workbooks, the first workbook contains a unique ID in a column as well as columns with name, age, skill level, skill name, expiry date in accordance to the unique ID. **NOTE: 1 Unique IDs may have 1 or more skill levels and skill names, different skill level = different row, same unique ID**
Now in the 2nd workbook, I would like to pull the data of the skill name with relation to the skill level using the unique ID as the input.

This is what I have made and the result is "SPILL!"

IF(VLOOKUP(@A:A,'[Data_Skill.xlsx]Sheet1'!$A$2:$D$5000,4,FALSE)="Level I",(VLOOKUP(@A:A,'[Data_Skill.xlsx]Sheet1'!$E$2:$E$5000,5,FALSE),"No Skill")

A Column being the unique ID and D being skill level and E being skill name.
Would like to know if there is another way of doing this or if anyone can help fix any wrongs in the formula.
If anymore information is needed, please feel free to ask.

Thank you

 

[Alex Blakenburg]

I am not at a computer at the moment, see if the explanation here (Example 6) works for you

Excel LOOKUP Function Examples with Video and Workbook

Excel LOOKUP function examples show how to get value from one-row or one-column range, or from array, with multiple rows and columns

www.contextures.com

 

[dudeinaghillie]

I am not at a computer at the moment, see if the explanation here (Example 6) works for you

Excel LOOKUP Function Examples with Video and Workbook

Excel LOOKUP function examples show how to get value from one-row or one-column range, or from array, with multiple rows and columns

www.contextures.com

Amazing, thank you again for the help.
Very much appreciated