Continued: VLookup with Variable Data Sets

[Tom]

I accidentally posted the message before completing the
questions....

**** VLOOKUP Formula & Sample Data *********

=VLOOKUP(A1,$D$1:$E$3,2,FALSE)

Column A Column B Column D Column E
$A$1 Arizona $A$# Arizona
$A$99 Arizona
$A$501 Arizona

********************************************

As shown in the sample data, I need to use cell
references that have e.g. same column identifiers but
different row identifiers.

No matter what row number, as long as I find "A" in the
cell reference, I need the VLOOKUP to cross-reference
e.g. "Arizona".

Does anyone have any suggestions how to do this?

Thanks!!!
Tom

 

[Debra Dalgleish]

The lookup list from your first message had an A for both Arizona and
California. In your second message you said an A in the reference should
indicate Arizona. If the lookup for California in the first message was
a typo, then the following formula should work:

=VLOOKUP(LEFT(A1,3),$D$1:$E$3,2,FALSE)