Looking for Values in Different Columns - VLOOKUP, MATCH, INDEX ???

[juandyer]

Hi All,

I just registered with this site and right off the bat I need help. The spreadsheet attached is one I have been working on. The main issue is that the data I'm looking for is not in a consistent column but in different columns instead.

Let me explain, my spreadsheet is made of two worksheets, one is called "Roster" and the other is called "Export Agent Data". The "Export Agent Data" worksheet contains Login IDs along with a series of Skill Numbers (SN) and Skill Levels(SL). However, those Skill Numbers are not dumped in any organized manner. I need to be able to look at specific Serial Numbers from the "Roster" worksheet and if the same number is found for a specif Login ID, display the number to the right of the Skill Number which is the Skill Level.

Can someone help decipher this?

My respects goes to whoever has the expertise to solve it.

Thanks in advance,

Juan