Add a column

Hi, I want to add RANK from column H to column E. The condition is: finding Dnaid in column G which occuries in column D.
For example:
G6606=7654. thus E1=27
SVCheck.xls
zhshqzycAsked:
Who is Participating?
 
SiddharthRoutCommented:
Just Copy this formula in Cell E1

=VLOOKUP(D1,G:H,2,0)

and pull it down.

Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.