<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
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.<br />
<br />
Example :<br />
Range NY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Range NJ<br />
ColumnA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Columnb &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ColumnA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ColumnB<br />
NY membership &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NJ Membership &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50<br />
<br />
I would like &nbsp;to use the same vblookup to populate the following column if possible &nbsp;The column I am trying to match on in the vblookup <br />
does not have the State. &nbsp;Is this possible?<br />
<br />
columna<br />
&nbsp;Membership &nbsp; &nbsp; &nbsp; &nbsp;=vlookup(A1,NY,1,0)
</div>
</div>


Experts,

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.

Example :
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?

columna
 Membership        =vlookup(A1,NY,1,0)

vblookup

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.