Use VLOOKUP
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"JE" wrote in message
...
Is there a way to have the lookup function look at multiple (2 columns)
and
return a
value?

For example:
Column A - I have different names appearing multiple times, for example,
Trade. In Column B, there are other references that appear multiple times
that I need to associate with Trade in a Look up, for example California
or
Alaska. In other words there are several subcategories of trade in Column
B
and I want to be able to specify a double column lookup so that Excel
doesn't
take the first occurrence as is the VLookup limitation.
Let's say in Column A, we have Trade (twice) but in Column B we would
have
5 subcategories of Trade such as Alaska and California etc etc. I want to
be
able to look up Trade as one part of the formula and then specify the
other
variable (such as California) from the next Column. So I want Trade and
California to be one lookup. Another time, I might want Trade and
Alaska.
See example below where I want to have my formula in another sheet that
will
pull from the reference Trade from Column A and the reference California
from Column B:

Column A Column B
Trade Alaska
DTY Some
DTD Some
Trade California

Thanks!