I am studying for a practical Excel test for a job promotion, and this topic has me lost. here goes.
I created a work book with an alphabetical of employees (test one).
I sorted and got all the data to move. Column a is employee Id numbers, column b is ID numbers, column C is telephone numbers, (test 2).
Now here is where I'm lost.
On another work sheet in the same work book, I have to be able to type in an ID number in workbook 2, column a, and have the data from Worksheet 1 appear in columns B (employee name which is column b and phone number which is column C)
I have seen various formulas, of which none are working.