Is there a way to use VLookup with another worksheet? I want to pull data from two different worksheets (same cells on each sheet) into a new worksheet.
Is there a way to use VLookup with another worksheet? I want to pull data from two different worksheets (same cells on each sheet) into a new worksheet.
Yes, there is, just mention the the sheet name in the value, table_array parameters.
Eg. Sheet1!$K$3:$M$80