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?
 
SiddharthRoutConnect With a Mentor Commented:
Just Copy this formula in Cell E1

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

and pull it down.

Sid
0
All Courses

From novice to tech pro — start learning today.