Jul 07 2020 03:35 PM
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
Jul 07 2020 10:50 PM
@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