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

[NeedForExcel]

So for eg, the 1st Serial Number 1757 is Found on multiple Cells on Export Agent Data Sheet..

What happens in that case?

[juandyer]

The number appears only one time per row so the most a Login ID can have a Skill Number is 1

[FDibbins]

TRy this, copied down and across...
=IFERROR(INDEX('Export Agent Data'!$C2:$CD2,MATCH(Roster!B$1,'Export Agent Data'!$B2:$CC2,0)),"")

[samba_ravi]

Please Login or Register  to view this content.

Try this in B2 and copy across
if it is not you are looking for please give manual result for 2 or 3 cases