using macro comparison need check two rows <Moved from Community Participation C
ID: 3563794 • Letter: U
Question
using macro comparison need check two rows
<Moved from Community Participation Center>
i have an employee name and salary in the Row A and B, if i give some names of employees in C i need to get that particular people name and salary in D and E row. is this possible in macro commands
using macro comparison need check two rows i have an employee name and salary in the Row A and B, if i give some names of employees in C i need to get that particular people name and salary in D and E row. is this possible in macro commands Any suggestion???Explanation / Answer
A to E are columns, not rows.
In D1 you could enter the formula =C1 to get the name you entered in C1 (though I don't know why you would want a second copy of the name).
In E1 you could enter the formula = VLOOKUP(C1,$A$1:$B$3,2,FALSE) to get the salary for the name in C1
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.