• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

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
0
zhshqzyc
Asked:
zhshqzyc
1 Solution
 
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now