One way


http://www.contextures.com/xlFunctions03.html

--

Regards,

Peo Sjoblom

"Barbie" wrote in message
...
Working on a worksheet trying to find a formula to read two columns
Hortizal
and Vertical and come back with one value. For example, it looks up the
product name and then looks down to see which country the product was sold
to
and puts that value correctly on the next sheet.