VLOOKUP with 2 Criterias

[MRozell]

I have
Column A Area
Column B Name
Column C #

Now in another Area I have
Column F Area
Column G #
Column H Name

In H I want to look at both Column F and G
LOOKUP Column F in Column A and
LOOKUP Column G in Column C
and return me the results from Column B

The same # may be in multi Areas so I need to look for both Area and #

[AlKey]

Try this
Enter in H2 and copy down

Please Login or Register  to view this content.