VLookup Help

[Geterc]

I am trying to take look up matching values from multiple sheets and return a value in anther column. 

Example 

I want B2 to be looked up against sheet3: C2:C3964 and if matched return the value in column D in sheet 3. 

Hope this makes sense. 

CG

[#2]

@Geterc The basic formula for that would be (with either commas or semi-colons separating the arguments within the function, depending on the local settings in your Excel):

=VLOOKUP(B2,Sheet3!C2:D3964,2,FALSE)

If you are on a modern version of Excel, the new XLOOKUP function will probably be a better option.

More about these functions here:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1