CODEWITHSUNDEEP
excel-formula
davidjwest
davidjwest

Reputation: 546

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?

Upvotes: 1

Views: 127

Answers (1)

Matt D. Webb
Matt D. Webb

Reputation: 3314

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:

enter image description here

Useful Reference

VLOOKUP function

Upvotes: 3

Related Questions