vlookup

donman1950 · Apr 28, 2004

I'M TRYING TO GET THE VLOOKUP TO CHOOSE THE ARTIST RELATED TO THE ND
NUMBER, HOWEVER IT IS GIVING ME A DIFFERENT RESULT...HELP

(SEE VLOOKUP RESULT BELOW)

VLOOKUP FORMULA (VLOOKUP(B50,NDC!$A$4:$B$55,2)

VLOOKUP VALUE TABLE
CLOUMN "A" COLUMN "B"
NDC ARTIST
59930163501 Alston, Gerald
59930150006 Bell, William
59930165302 Benton, Brook
59930165301 Blue Magic
59930157002 Brandy
59930156001 Brown, James
59930152002 Brown, Maxine
59930164702 Brownstone
59930151504 Burke, Solomon
59930156002 Chandler, Gene
59930150802 Clapton, Eric
59930157502 Clarke, Dee
59930171501 Dells, The
59930162001 Don and Juan
59930167002 Downing, Will
59930166002 Dramatics, The
59930157003 Drifters, The
59930160902 Earth, Wind, & Fire
59930151702 Edwards, Tommy
59930154901 El Chicano
59930165002 Four Tops, The
59930153201 Houston, Whitney
59930168001 Intruders, The
59930153002 Jackson, Chuck
59930160201 James & Boby Purify
59930099612 Jones, George
59930157501 King Curtis
59930151701 Knight, Gladys
59930150008 Little Anthony & The Imperials
59930150201 LL Cool J
59930162101 Lynn, Barbara
59930166003 Maco
59930167003 Main Ingredient, The
59930171401 Mel & Tim
59930171402 Neville, Aaron
59930153202 Neville, Aaron
59930152001 Platters, The
59930099613 Pride 'n' Politix
59930150301 Rahsaan Patterson
59930163601 Rascals, The
59930160901 Robinson & The Miracles, Smokey
59930151005 Rogers, Kenny
59930153001 Ruby & The Romantics
59930158701 Santana
59930162401 Simone, Nina
59930150801 Simply Red
59930166001 Sly & The Family Stone
59930171403 Spinners, The
59930150302 Stafford, Terry
59930157001 Temptations, The
59930157009 Twitty, Conway
59930157503 Warwick, Dione

THIS IS THE RESULT I GET FOR THE VLOOKUP FORMULA

Stafford, Terry 59930156001
Stafford, Terry 59930156002
Stafford, Terry 59930151701
Little Anthony & The Imperials 59930150008
Jones, George 59930150006
Stafford, Terry 59930151702
Stafford, Terry 59930151504
Warwick, Dione 59930164702
Stafford, Terry 59930151005
Stafford, Terry 59930152001
Stafford, Terry 59930152002
Stafford, Terry 59930153001
Stafford, Terry 59930153002
Twitty, Conway 59930157501
Twitty, Conway 59930157502
Warwick, Dione 59930157503
Rahsaan Patterson 59930150301
Rahsaan Patterson 59930150302
Temptations, The 59930157001
Temptations, The 59930157002
Temptations, The 59930157003
Twitty, Conway 59930157009
Warwick, Dione 59930162001
Warwick, Dione 59930162101
Warwick, Dione 59930162401
LL Cool J 59930150201
Stafford, Terry 59930154901
Warwick, Dione 59930158701
Warwick, Dione 59930160201
Warwick, Dione 59930163601
Warwick, Dione 59930165301
Warwick, Dione 59930165302
Jones, George 59930099613
Simply Red 59930150801
Stafford, Terry 59930150802
Warwick, Dione 59930163501
Warwick, Dione 59930171501
Warwick, Dione 59930171401
Warwick, Dione 59930171403
Warwick, Dione 59930171402
Warwick, Dione 59930160901
Warwick, Dione 59930160902
Stafford, Terry 59930153201
Stafford, Terry 59930153202
Warwick, Dione 59930165002
Warwick, Dione 59930166003
Warwick, Dione 59930166001
Warwick, Dione 59930166002
Warwick, Dione 59930167003
Warwick, Dione 59930167002
Warwick, Dione 59930168001
Jones, George 5993009961

Frank Kabel · Apr 28, 2004

Hi
try
=(VLOOKUP(B50,NDC!$A$4:$B$55,2,False)

-----Original Message-----
I'M TRYING TO GET THE VLOOKUP TO CHOOSE THE ARTIST RELATED TO THE NDC
NUMBER, HOWEVER IT IS GIVING ME A DIFFERENT RESULT...HELP

(SEE VLOOKUP RESULT BELOW)

VLOOKUP FORMULA (VLOOKUP(B50,NDC!$A$4:$B$55,2)

VLOOKUP VALUE TABLE
CLOUMN "A" COLUMN "B"
NDC ARTIST
59930163501 Alston, Gerald
59930150006 Bell, William
59930165302 Benton, Brook
59930165301 Blue Magic
59930157002 Brandy
59930156001 Brown, James
59930152002 Brown, Maxine
59930164702 Brownstone
59930151504 Burke, Solomon
59930156002 Chandler, Gene
59930150802 Clapton, Eric
59930157502 Clarke, Dee
59930171501 Dells, The
59930162001 Don and Juan
59930167002 Downing, Will
59930166002 Dramatics, The
59930157003 Drifters, The
59930160902 Earth, Wind, & Fire
59930151702 Edwards, Tommy
59930154901 El Chicano
59930165002 Four Tops, The
59930153201 Houston, Whitney
59930168001 Intruders, The
59930153002 Jackson, Chuck
59930160201 James & Boby Purify
59930099612 Jones, George
59930157501 King Curtis
59930151701 Knight, Gladys
59930150008 Little Anthony & The Imperials
59930150201 LL Cool J
59930162101 Lynn, Barbara
59930166003 Maco
59930167003 Main Ingredient, The
59930171401 Mel & Tim
59930171402 Neville, Aaron
59930153202 Neville, Aaron
59930152001 Platters, The
59930099613 Pride 'n' Politix
59930150301 Rahsaan Patterson
59930163601 Rascals, The
59930160901 Robinson & The Miracles, Smokey
59930151005 Rogers, Kenny
59930153001 Ruby & The Romantics
59930158701 Santana
59930162401 Simone, Nina
59930150801 Simply Red
59930166001 Sly & The Family Stone
59930171403 Spinners, The
59930150302 Stafford, Terry
59930157001 Temptations, The
59930157009 Twitty, Conway
59930157503 Warwick, Dione

THIS IS THE RESULT I GET FOR THE VLOOKUP FORMULA

Stafford, Terry 59930156001
Stafford, Terry 59930156002
Stafford, Terry 59930151701
Little Anthony & The Imperials 59930150008
Jones, George 59930150006
Stafford, Terry 59930151702
Stafford, Terry 59930151504
Warwick, Dione 59930164702
Stafford, Terry 59930151005
Stafford, Terry 59930152001
Stafford, Terry 59930152002
Stafford, Terry 59930153001
Stafford, Terry 59930153002
Twitty, Conway 59930157501
Twitty, Conway 59930157502
Warwick, Dione 59930157503
Rahsaan Patterson 59930150301
Rahsaan Patterson 59930150302
Temptations, The 59930157001
Temptations, The 59930157002
Temptations, The 59930157003
Twitty, Conway 59930157009
Warwick, Dione 59930162001
Warwick, Dione 59930162101
Warwick, Dione 59930162401
LL Cool J 59930150201
Stafford, Terry 59930154901
Warwick, Dione 59930158701
Warwick, Dione 59930160201
Warwick, Dione 59930163601
Warwick, Dione 59930165301
Warwick, Dione 59930165302
Jones, George 59930099613
Simply Red 59930150801
Stafford, Terry 59930150802
Warwick, Dione 59930163501
Warwick, Dione 59930171501
Warwick, Dione 59930171401
Warwick, Dione 59930171403
Warwick, Dione 59930171402
Warwick, Dione 59930160901
Warwick, Dione 59930160902
Stafford, Terry 59930153201
Stafford, Terry 59930153202
Warwick, Dione 59930165002
Warwick, Dione 59930166003
Warwick, Dione 59930166001
Warwick, Dione 59930166002
Warwick, Dione 59930167003
Warwick, Dione 59930167002
Warwick, Dione 59930168001
Jones, George 59930099612

Charlie · Apr 28, 2004

Try =VLOOKUP(B50,NDC!$A$4:$B$55,2,FALSE)

Charlie O'Neill

Guest · Apr 28, 2004

VLOOKUP(B50,NDC!$A$4:$B$55,2,0) works if the ref
column 'A' is sorted

vlookup

donman1950

Frank Kabel

Charlie

Guest