LOOKUP not working correctly

Hi. I've been using the Lookup formula for a while now and it has been working fine, that is until today. I am creating a new spreadsheet for use with writing our templates we use to program our radios with. What is happening now is that when the LOOKUP is looking up some of the values, it is either returning the wrong information or showing #N/A. For the life of me, I can't figure out what is going on. I have attached a sample file containing a sample of the sheet I'm creating and the table I'm looking up the data from. The formula as I have it written in the table is =LOOKUP(B2,'All Talkgroups'!B:B,'All Talkgroups'!C:C). As you can see on the sample below, it works for Channels 11-16 correctly. Any ideas?

CHANNEL PERSONALITY 24 NES B
1 3 P403 TRAING 3
2 5 FB16 VLF
3 7 AIRPORT ON PROPERTY
4 9 Z506 WATER
5 B Z3 4
6 D LV FDFG
7 F P601 SRT1
8 11 #N/A
9 13 #N/A
10 15 #N/A
11 17 N B11 OD1
12 19 N B12 OD2
13 1B N B13 OD3
14 1D N B14 LD3
15 1F N B15 LD2/TNT 7 GSE
16 21 N B16 LD 1

All Talkgroups:

Talkgroup ID (Decimal) Talkgroup ID (Hex) Talkgroup Description
1 1 Default
2 2 GVPD MAIN
3 3 N B1 OHC
5 5 N B2 OHC1
6 6 GVPD TACT
7 7 N B3 OHC2
9 9 N B4 OHC3
11 B N B5 OHC4
13 D N B6 OW
15 F N B7 OW1
17 11 N B8 OW2
19 13 N B9 OW3
21 15 N B10 OD
23 17 N B11 OD1
25 19 N B12 OD2
27 1B N B13 OD3
29 1D N B14 LD3
31 1F N B15 LD2/TNT 7 GSE
33 21 N B16 LD 1
35 23 N C1 U&S
37 25 N C2 U&S1/TNT 8 GSEM
39 27 N C3 U&S2
41 29 N C4U&S3
42 2A VU SPE1
43 2B N C5 TEST1/VU SPE2
45 2D N C6 TEST2
47 2F N C7 METER
49 31 N C8 METER1
51 33 N C9 RECNECT
53 35 N C10 RECNECT1
55 37 N C11 ENGNEER1
57 39 N C12 ENGNEER2
59 3B N C13 SAFETY/N D2 SPR
61 3D N C14 GENSVCS
63 3F N C15 FLEET
65 41 N C16 SECURITY
67 43 N D1 TEL
101 65 N D5 911
103 67 Z601 OHC
105 69 Z602 OHW
107 6B Z603 OHD
109 6D Z604 LOAD
111 6F Z605 U&S
113 71 Z606 TST
115 73 Z607 METER
117 75 Z608 RECONECT
119 77 Z609 ENG
121 79 Z610 SFT
123 7B Z611 GS
125 7D Z612 FLEET
127 7F Z613 SECURITY


Thanks.

Wayne
EXAMPLE.xlsx

Solution with VLookup.

See the attached file.

Wayne

Have you tried VLOOKUP?

Formula:

Please Login or Register  to view this content.

Or am I totally and utterly misinterpreting this?

Wayne

Have you tried VLOOKUP?

For example, in C2 and copied down.

Formula:

Please Login or Register  to view this content.

Or am I totally and utterly misinterpreting this?