Lookup?

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,970
Office Version
  1. 2010
Platform
  1. Windows
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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
=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
 
Upvote 0
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
 
Upvote 0
Make sure that the reference numbers are formatted the same...meaning, one set might be text while the other a true number.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top