C
C.
Hi all,
I have two separate worksheets within the same workbook
The first worksheet (ConsultCall!) looks like this:
ID# Percentage
1-1232 50%
2-345 61%
10-12 89%
15-98753 25%
In another sheet (Calc!), I have a similar ID# column, but the ID #'s
are not in the same order as the first worksheet and some ID #'s are
in one that are not in the other column. Basically I want to be able
to match on unique ID #'s and then return the corresponding percentage
value in another column in the second worksheet for that ID # in the
first worksheet.
ID#
15-98753
10-12
2-345
Any thoughts? Thanks!
I have two separate worksheets within the same workbook
The first worksheet (ConsultCall!) looks like this:
ID# Percentage
1-1232 50%
2-345 61%
10-12 89%
15-98753 25%
In another sheet (Calc!), I have a similar ID# column, but the ID #'s
are not in the same order as the first worksheet and some ID #'s are
in one that are not in the other column. Basically I want to be able
to match on unique ID #'s and then return the corresponding percentage
value in another column in the second worksheet for that ID # in the
first worksheet.
ID#
15-98753
10-12
2-345
Any thoughts? Thanks!