Pull all lines from a table if value matches identifier in another table

Hi,

New to this forum and relatively new to formulas, so apologize for the very basic question. I have 2 tables as follows:

Table 1
#
1
2
3
4

Table 2
# | Text
1 | text 1
1 | text 2
1 | text 3
2 | text 4
2 | text 5
2 | text 6

I would like to pull all the text from table 2 if the # is found in table 1. How would I do this?

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(take a look at the VLOOKUP() function)

	A	B
3	1	text 1
4	2	text 4
5	3	#N/A
6	4	#N/A

B3=IFERROR(VLOOKUP(A3,$A$10:$B$15,2,0),"")