Lookup Functions for a range of cells

Hang on.... Hang on!

Take a step back. You want to type any employee number from 1 to 8. You put that number into A1. Then A1 = whatever number you put in there. Then B1 = the forumula I posted above, C1 = the formula I posted above. Have you tried it???

You can copy the whole setup down a few rows and enter different employee numbers in A2, A3, A4, etc.

You will only ever enter one employee number into one cell, and that cell will be evaluated by the Vlookup function.

Maybe you want to post an example of your file, so we can have a look and explain some more?
You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

cheers

This is what I have, it doesn't use vlookup, just regular lookup.

B1 and C1 will stay blank until you decide to input a employee number in A1

B1:

=IF(A1="","",LOOKUP(A1,Sheet2!$A$1:$A$8,Sheet1!$B$1:$B$8))

C1:

=IF(A1="","",LOOKUP(A1,Sheet2!$A$1:$A$8,Sheet1!$C$1:$C$8))

The range is static, so you can paste down a few more rows for comparison.

Good luck