V lookup across two worksheets 1

[IngDep]

Have three worksheets.
Is it possible to perform a vlookup across multiple worksheets in a workbook? The objective is to populate the "FeeAmt" column in Worksheet 1 with data that resides in Worksheet 2 or Worksheet 3.

Worksheet 1 has the following columns
Name---------FeeAmt
123-AD
246-GG

Worksheet 2 has the following columns
Name---------FeeAmt
123-AD-------20
124-AE-------30

Worksheet 3 has the following columns
Name---------FeeAmt
200-AD-------65
246-GG-------90

 

[SkipVought]

Hi,

The strategy I would use is to consolidate the data into ONE SHEET.

Then the data analysis/reporting/lookups will be a piece of cake.

Excel is not designed to process multiple data sources with lookups.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[IngDep]

There are 64000 rows in Worksheet 1 and 50000 rows in Worksheet 2.

The data is sorted in the Worksheets whereby the names are not duplicated in the worksheets. For example, Worksheet 1 contain names from say "123AD" to "199DZ" and then Worksheet 2 is a continuation of the names, from say
"200AD" to "999ZZ."

I need the Vlookup to look within both worksheets and extract the Fee Amt from Worksheets 2 or 3. If the Name is not located on Worksheets 2 or 3, then I need a blank ("") to display.

Is this possible?

 

[SkipVought]

[tt]
=if(isna(match(LookupRef,Sheet2!lookupcolumn,0)),Sheet3VLOOKUP,Sheet2VLOOKUP)
[/tt]
It may be necessary to also do an ISNA on the sheet3 match.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]