Data transfer problem

[borchesz]

I am working on a project that deals with two sets of information. M
first set of information includes:

A list of all the state abbreviations in the first column, the secon
column has prices.

E.X. AL (A1), AR (A2) ....and so on all the way through the 5
states.
EX. $1.14(B1), $1.20(B2)

ex--so AL has a price of $1.14, $AR has a price of 1.2 and so on...


My second set of information includes:
A list of state abbreviations, out of alphabetical order.

I want to be able to merge these two sets of information around th
prices. I do not want to go through the list and find each A
abbreviation and have to type in $1.14,


I was wondering if there was a way to run a function that would sca
the second set of information for AL, since it is listed multipl
times, unlike the first set of information. Once it finds AL, I wan
it to match it up with it's correct price aka $1.14

***(i can't sort the second set of information into alphabetical orde
because it needs to stay in the orignal order it came in

 

[Dave Peterson]

If your data is in a column, maybe you could use a helper column and drag a
formula down.

Say your state/price stuff is in A:B of sheet1.
Your states are in column A of Sheet2.

Then put this in a helper cell:
=vlookup(a1,sheet1!$a:$b,2,false)
And drag it down.