Is it possible to use Vlookup with a range?

问题:

I've not written any macros for some years so am rusty.

With Excel 2007 I need go through a whole column of data (assume it's column A) and for each cell in that column try to find the value in column C of another worksheet.

Can Vlookup do this or would I need to use another function?

回答1:

A basic example using a second sheet reference (Sheet2), with a range in column A:

=VLOOKUP(Sheet2!C2,A2:B5,2,FALSE)

Below is a working screenshot example:

Useful Reference

VLOOKUP function