If I have columns that I am trying to pull data from using a VB lookup from multiple named ranges, the contain the same literal except for the state, is there a way to do this without changing the original input.
Range NY Range NJ
ColumnA Columnb ColumnA ColumnB
NY membership 25 NJ Membership 50
I would like to use the same vblookup to populate the following column if possible The column I am trying to match on in the vblookup
does not have the State. Is this possible?