How do you do vlookup in two different spreadsheets

[Pack10]

I can do simple vlookups, but how do you do a vlookup with two excel sheets. That real life stuff
I will often be given two sheets. I have been importing to access and doing unmatched queries.....
but i want to know how to do it in vlookup.

 

[Gavona]

=vlooklup(LookupValue,myRange,columnNo,rangeLookup)

Best advice is to name your lookup range.
If the lookup range is in the current workbook then when you get to the MyRange part just press F3 to get a list of the named ranges.

If the lookuprange is in another workbook then one cheat* is to temporarily move the sheet into the current workbook, construct your lookup and finally move the sheet back into the original workbook. This means that the formula looks simpler while you are constructing it.

Finally close the workbook with the lookup range before you save the workbook with your lookup formula in it. This will ensure that the path (or relative path) is saved with the formula, not just the workbook name.

*You don't need the cheat - just click into the other workbook and select the range.

Also you have talked of "two excel sheets" what you didn't tell us is if these were in different workbooks.

Gavin

 

[SkipVought]

Why is it on 2 sheets?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Pack10]

I'm an access guy looking to upgrade my excel skills. Normally I would import the sheets and do an unmatched query...I wanted to know how to do it in excel.

 

[Pack10]

sorry, yes different workbooks.