Lookup?

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Fropm this list - I need to confirm if the numbers in column D appear in column A, result in E
HAMMONDS - FA.xls
ABCDE
1144482MrDavidMeadReference
2159956MrReubenStevens144482
3170908MrRobertMullett174653
4173722MrsIreneNicholson219833
5174653MrsLisaPark245826
6175150MissLeanneWheater288328
7181242MrCraigNewman311779
8187837MrsCatherinePayne313089
9188463MrStephenHunt331670
Sheet1


Whats the best way? Vlookup?

TIA
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
VLOOKUP would work but COUNTIF is simpler.

Code:
=COUNTIF(A:A,D2)
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
=VLOOKUP(D2,A:A,2,FALSE)

?

I tried the above and it resulted in N/A

:rolleyes:
HAMMONDS - FA.xls
ABCDE
1144482MrDavidMeadReference
2159956MrReubenStevens144482#N/A
3170908MrRobertMullett174653#N/A
4173722MrsIreneNicholson219833#N/A
5174653MrsLisaPark245826#N/A
6175150MissLeanneWheater288328#N/A
7181242MrCraigNewman311779#N/A
8187837MrsCatherinePayne313089#N/A
Sheet1
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764

ADVERTISEMENT

=vlookup(d1,a:a,1,false)

?

I tried the above and it reculted in N/A

Of course it did, D1 contains the word Reference!
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
works for me
Book1
ABCDE
1144482Mr David MeadReference
2159956Mr Reuben Stevens144482144482
3170908Mr Robert Mullett174653174653
4173722Mrs Irene Nicholson219833#N/A
5174653Mrs Lisa Park245826#N/A
6175150Miss Leanne Wheater288328#N/A
7181242Mr Craig Newman311779#N/A
8187837Mrs Catherine Payne313089#N/A
9188463Mr Stephen Hunt331670#N/A
Sheet1
 

ExcelChampion

Well-known Member
Joined
Aug 12, 2005
Messages
976

ADVERTISEMENT

Make sure that the reference numbers are formatted the same...meaning, one set might be text while the other a true number.
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Texaslynn

I mirrored your example & Mine isn't working
HAMMONDS - FA.xls
ABCDE
1144482MrDavidMeadReference
2159956MrReubenStevens144482#N/A
3170908MrRobertMullett174653#N/A
4173722MrsIreneNicholson219833#N/A
5174653MrsLisaPark245826#N/A
6175150MissLeanneWheater288328#N/A
7181242MrCraigNewman311779#N/A
8187837MrsCatherinePayne313089#N/A
Sheet1
 

ExcelChampion

Well-known Member
Joined
Aug 12, 2005
Messages
976
Make sure that the reference numbers are formatted the same...meaning, one set might be text while the other a true number.

Copy a blank cell, select one set of reference numbers, and then Pastespecial/values/add. Do the same for the other set.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top