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
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