Lookup Help

  • Thread starter Thread starter babar
  • Start date Start date
B

babar

Hi Eveybody,
I guess this is an easy case for most of you but I'm lost.
I have 2 columns A (country codes) & B (Zones).
I would like when entering US for example to get B or Italy C....
Tks for your answer and all the best from CH.
rgds
Baba
 
=VLOOKUP(D1,$A$1:$B$100,2,1) Where D1 is the input of the country code
to find, returned will be the zone for that code. Adjust the lookup
range $A$1:$B$100 to match your data in columns A and B.

HTH
 
From Babar:> Hi Bruce,
Tks for your support.
Best rgds from a Frenchman working in Switzerland.
Bruno
P.S I appreciated also your philosophy.
Click to expand...

You are most welcome. Glad to help. Thanks for the feedback, which I
posted here so others will know this solution worked for you.

Cheers from a Michigander working in Minnesota!

Bruce
 
Back
Top