V look up

Hello Avtar

Thank you for your question and welcome to the forum.

The VLOOKUP function has 4 parts: 1. Lookup value. 2. Table array. 3. Column index number. 4. Range lookup.

Say you are using the vlookup to pull the person's address over to the sheet you have NI numbers and pay details on.

I would say in this example that the NI number would be your lookup value, as it is unique for each person.

For this to work, the NI number will need to be the first/leftmost column in the table with the address.

I've attached an example with a vlookup formula to demonstrate - the vlookup formula is in the yellow cells on the Pay sheet.

Kind regards
Amanda