Help needed

[Oliver3000]

I need help with the following. If I type a text name in a single cell, I need to get text and number data in columns for this name. A simple example, if I type the text "dog" in one cell, I should get the following data in several columns and in the same row, "big", "hungry 100", "12/25", "Monday", "$350". What is the best way to do this? The preferred option is to enter the text instead of selecting it from the filter

 

[Peter_SSs]

Welcome to the MrExcel board!

A simple example, if I type the text "dog" in one cell,

Is that in a particular column?

Should we just guess what should be entered if you type "cat" in the cell/column?

We need more detail about just what you have, where it is and what you are trying to achieve.

The preferred option is to enter the text instead of selecting it from the filter

Further to my previous point, can you explain what the reference to a filter is about?

I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.

 

[Oliver3000]

Welcome to the MrExcel board!


Is that in a particular column?

Should we just guess what should be entered if you type "cat" in the cell/column?

We need more detail about just what you have, where it is and what you are trying to achieve.


Further to my previous point, can you explain what the reference to a filter is about?

I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.

It should pull data from an existing table.

 

[jdellasala]

This is what I got from your question. Data Table:

Book1
	I	J	K	L	M	N
1	Input	Item1	Item2	Item3	Item4	Item5
2	Dog	big	hungry 100	25/12	Monday	$350
3	Cat	small	full 100	26/12	Tuesday	$400
Sheet1

Input Table:

Book1
	A	B	C	D	E	F
1	Input	Item1	Item2	Item3	Item4	Item5
2	Dog	big	hungry 100	12/25	Monday	$350
Sheet1

Cell Formulas
Range	Formula
B2	B2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,2,0),""),"")
C2	C2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,3,0),""),"")
D2	D2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,4,0),""),"")
E2	E2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,5,0),""),"")
F2	F2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,6,0),""),"")

Cells with Data Validation
Cell	Allow	Criteria
A2	List	=$I$2:$I$3

The Input column in the Input Table uses a Data Validation List built from the Input Column in the Data Table. They are both Excel Tables, and the validation list will grow as the data in the Data Table grows.
Since spilled data isn't available in a table, each column in the Input Table requires an VLOOKUP formula.
This should give you a starting point.

 

[Peter_SSs]

It should pull data from an existing table.

You clearly know what your data is like and what you are trying to achieve, but we only know what you tell or show us which so far is pretty much nothing. I think that there will be people who will try to help but we have to understand ...

what you have & where it is and also what you want & where it is to be.

A good way to help show/describe that is to give a small set of sample dummy data with XL2BB (link provided previously) & describe your requirement carefully in relation to that sample data.

 

[Oliver3000]

This is what I got from your question. Data Table:

Book1
	I	J	K	L	M	N
1	Input	Item1	Item2	Item3	Item4	Item5
2	Dog	big	hungry 100	25/12	Monday	$350
3	Cat	small	full 100	26/12	Tuesday	$400
Sheet1

Input Table:

Book1
	A	B	C	D	E	F
1	Input	Item1	Item2	Item3	Item4	Item5
2	Dog	big	hungry 100	12/25	Monday	$350
Sheet1

Cell Formulas
Range	Formula
B2	B2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,2,0),""),"")
C2	C2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,3,0),""),"")
D2	D2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,4,0),""),"")
E2	E2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,5,0),""),"")
F2	F2	=IF([@Input]<>"",IFERROR(VLOOKUP([@Input],tblData,6,0),""),"")

Cells with Data Validation
Cell	Allow	Criteria
A2	List	=$I$2:$I$3

The Input column in the Input Table uses a Data Validation List built from the Input Column in the Data Table. They are both Excel Tables, and the validation list will grow as the data in the Data Table grows.
Since spilled data isn't available in a table, each column in the Input Table requires an VLOOKUP formula.
This should give you a starting point.

Thank you.