Hi,

Am Tue, 9 Jun 2015 18:54:07 -0700 (PDT) schrieb Munster:

Sheet 2
A1 has Location B1 has Product
A2 has FR001 B2 has Apples
A3 has FR002 B3 has Oranges
A4 has FR003 B4 has Lemons

Sheet 1
A1 has Product B1 has Location
A2 B2

in B2 try:
=INDEX(Sheet2!A:A,MATCH(A2,Sheet2!B1:B100,0))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional