how to match Id and Student ID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Please suggest me how to match Id and Student ID. I have 3000 Student ID and
8000 id is same excel worksheet.
Thanks a lot.


id Student ID
195254 195903
195703 196010
195903 198787
196010 205653
196643 208498
196646 209069
196675 209168
197301 210864
197444 210934
198712 221614
200720 370825
202194 451482
203212 451761
210864
 
Perhaps you want to do something like this:
In C2: =IF(ISNUMBER(MATCH(B2,A:A,0)),"Y","")
Copy C2 down to last row of data in col B. Col C will flag those Student IDs
which are found in IDs (in col A) with a "Y", otherwise blanks ("") will be
returned.
 
A variation of Max's offering, will tell you which row in the ID list the
Student ID shows up in. Assumes IDs in A, Student ID in column B. Formula
goes into column C (or any other available column)
=IF(ISNA(MATCH(B2,A$1:A$8000,0)),"no match","ID is in Row: " &
MATCH(B2,A$1:A$8000,0))
 
Thanks a lot both of you.


JLatham said:
A variation of Max's offering, will tell you which row in the ID list the
Student ID shows up in. Assumes IDs in A, Student ID in column B. Formula
goes into column C (or any other available column)
=IF(ISNA(MATCH(B2,A$1:A$8000,0)),"no match","ID is in Row: " &
MATCH(B2,A$1:A$8000,0))
Click to expand...
 
Back
Top