Userform creation

[Kiwi den]

I am looking to create a userform that will search across many rows or columns depending on what is asked for
ie: database will have the following
A1 = Blue, A2= Weekly, A3= Texas, A4= 2019, A5 will have a jpeg picture
B1 = Red, B2 = Fortnight B3 = Maine, B4= 2020, B5 will have a jpeg picture
C1= Green, C2= Daily, C3 Iowa, C4 = 2020, C5 will have a jpeg picture

What I am looking for will be a search field in the user form , that if any of the data from A1 - C4 is entered then the entire row will be displayed including the relevant picture

if anyone can point me to where I can get tips or ideas on ho to achieve this would be very much appreciated

 

[Yongle]

How many boxes on the userform ?
- ONE ?
- FOUR ? (ie colour, frequency, state, year)

Does your data look like this?

Book1
	A	B	C
1	Blue	Red	Green
2	Weekly	Fortnight	Daily
3	Texas	Maine	Iowa
4	2019	2020	2020
5	a picture	a picture	a picture
Sheet6

Which rows are visible if Green and Maine are entered in search box ?

Should search box contain dropdown ?
- is user allowed to type a value in search box ?