Need some help with indexMatch.
I have two worksheets (Sameworkbook)
worksheet 2 has the data that I need to look at example
Col. C:
Joe
Mark
Bill
Now, match the names above to those in worksheet 1 and return the value in col. A of worksheet 1 to col.B of worksheet 2
note: worksheet 1has the same names I just need to get its matching value.
I was told index/match might be able to do this.
can someone give me a start?
I have two worksheets (Sameworkbook)
worksheet 2 has the data that I need to look at example
Col. C:
Joe
Mark
Bill
Now, match the names above to those in worksheet 1 and return the value in col. A of worksheet 1 to col.B of worksheet 2
note: worksheet 1has the same names I just need to get its matching value.
I was told index/match might be able to do this.
can someone give me a start?