PDA

View Full Version : Solved: Vlookup



Nosstech
09-09-2008, 04:19 AM
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.

jumbel
09-09-2008, 04:41 AM
Yes, there is, just mention the the sheet name in the value, table_array parameters.

Eg. Sheet1!$K$3:$M$80