ADVICE: Simple Lookup Tool

[NeoSez]

Can someone recommend if VBA is the way to go or if using this Dropdown list to look up numbers is better? I am a newbie so don't want anything so complicated that I will not understand. It's my first time using a combo box.
I created this simple lookup, but it's out of whack. I can not understand why the formula is in D14 and brought over the entire column from Sheet1. It will not allow me to move it back to B4 and gave me an ARRAY error. Did I write it incorrectly? I just want to search from rows 2-15, not insert it all. So this should be a simple exercise for pros, but I am a beginner, so I am stumped on how to fix this.

=IF(ISNUMBER(SEARCH($B$4,Sheet1!B2:B15)),Sheet1!A2:A15,"")

So I tried to use this formula instead, but it returns an #N/A error.

=VLOOKUP(B4,Sheet1!A2:B171,2,0)

So in short,
Enter number or select from dropdown
Returns the Licence from Sheet 1.

Thank you for your help.

Sheet1

Licence	No.
123456	009
123457	010
123458	011
123459	012
123460	013
123461	014
123462	015
123463	016
123464	017

Sheet2

Sample Lookup.xlsm
	A	B	C
1	Enter No.
2
3
4		010
5
6
7	Your Licence is:
8		#N/A
9
10
Sheet2

 

[Dave87]

=LOOKUP(B4,Sheet1!$B$1:$B$10,Sheet1!$A$1:$A$10)

or if you dont have the Lookup function use

=INDEX(Sheet1!$A$1:$B$10,MATCH(Sheet2!B4,Sheet1!$B$1:$B$10,0),1)

 

[NeoSez]

Thank Dave87 Greatly appreciate the quick response.