v lookup function

Hello Davida,

Thank you for your question.

Here is an example v-lookup:
=VLOOKUP(A3,[Book2]Sheet1!$A$1:$K$550,11,FALSE)

A3 is what is being looked up, what I want to find in the other workbook.
[Book2]Sheet1!$A$1:$K$550 is the area that I want the v-lookup to search.
- the first column of this area must contain the v-lookup values
- the area must also include the items you want returned
11 is because I want excel to return whatever is in the 11th column (K) of the area
False is because I want an exact match. if it doesn't find an exact match it will return #N/A and I therefore know it doesn't exist in the other workbook.

If you would like more specific information feel free to reply with further clarification and details.

Hope this has helped though.


Kind regards

Cindy
Microsoft Office Trainer