Microsoft Office Forums - View Single Post - [Solved] VLOOKUP for country / country code

Thread: [Solved] VLOOKUP for country / country code

View Single Post

Old

09-24-2017, 08:56 PM

mikehk

mikehk is offline

mikehk uses Windows 10

Windows 10 mikehk uses Office 2013

mikehk uses Office 2013

Office 2013

Novice

The original poster

Join Date: Sep 2017

Posts: 15

mikehk is on a distinguished road

Default

VLOOKUP for country / country code

I tried many formulas and either I get #VALUE or #N/A,
someone please help.

=VLOOKUP(A1,Sheet2!A15:B37,2,0)

I have in Sheet 2

cell A15 | B15

Australia | 61
Canada | 1
China | 86

Reply With Quote