Using text input box to call cell values.

[mrmatt36]

Looking for info on how to create a text input box on a new sheet that will allow user to input a part number hit a button and have it search data on another sheet and retrieve/display the data related to this item from the other cells.

example- sheet one will have all the part information, column a on sheet one will have the part number, column b will have part name, column c will have part vendor, column d will have the location.
sheet 2 will simply have a text input box with a label - "Input part number to lookup" then have a button "lookup" or "reset" reset will just clear the text box, when you hit lookup it will search column a on sheet one for a match, if matching part number is found it will populate the data for this part from columns a, b, c,& d from sheet one to information box on sheet 2 (same sheet where part number is entered). the text input box and the populated information should be on fixed fields on sheet 2 not a popup box.

 

[mrmatt36]

the vendor info is needed but not to be blantly displayed.

 

[dreid1011]

Here is one option:

Book1
	A	B	C	D	E	F	G	H
1
2					John's Hardware
3					Part Lookup
4
5
6			Part Number
7			55531
8
9
10
11
12			Part Number:		55531
13
14			Part Name:		1/4" stainless washer
15
16			Vendor:		Vendor #1
17
18			Location:		Box 42
19
Sheet2

Cell Formulas
Range	Formula
E12	E12	=XLOOKUP(C7,Sheet1!$A$2:$A$10,Sheet1!$A$2:$A$10,IF(C7="","","Item Not Found"))
E14	E14	=XLOOKUP(C7,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,"")
E16	E16	=XLOOKUP(XLOOKUP(C7,Sheet1!$A$2:$A$10,Sheet1!$C$2:$C$10,""),Sheet3!A2#,Sheet3!B2:B4,"")
E18	E18	=XLOOKUP(C7,Sheet1!$A$2:$A$10,Sheet1!$D$2:$D10,"")

With a new table on sheet 3:

Book1
	A	B
1	Unique Vendor	Mask
2	national stainless products	Vendor #1
3	grip rite fasteners	Vendor #2
4	national tooling	Vendor #3
Sheet3

Cell Formulas
Range	Formula
A2:A4	A2	=UNIQUE(Sheet1!C2:C10)
B2:B4	B2	=BYROW(A2#,LAMBDA(rw,"Vendor #"&ROW(rw)-1))
Dynamic array formulas.

 

[Skyybot]

I replicated your data (below). I created a UserForm (attached picture) that opens with Workbook Open event. As long as all of your Sheets are formatted like my picture, the form will work with any ActiveSheet. If you're interested, I can share the UserForm and Module.

PartForm.xlsm
	A	B	C	D
1	Part Number	Description	Vendor	Location
2	55531	1/4" Stainless Washer	National Stainless Products	Box 42
3	55532	5/16" Stainless Washer	National Stainless Products	Box 43
4	55533	3/8" Stainless Washer	National Stainless Products	Box 44
5	55534	1/2" Stainless Washer	National Stainless Products	Box 45
6	55535	1" Drywall Screws	Grip Rite Festeners	Bay3 - #13
7	55536	1-1/4" Drywall Screww	Grip Rite Festeners	Bay3 - #14
8	55537	1-5?8 Drywall Screws	Grip Rite Festeners	Bay3 - #15
9	55538	6-32x3/4" Machine Screws	National Tooling	Shelf 23
10	55539	6-32x1" Machine Screws	National Tooling	Shelf 24
Sheet1