add values from multiple columns in one worksheet to another worksheet based on a match

[MDewane]

Worksheet 1= there is data in each cell in Columns A – K For any given row, the values in Columns G, H, I, J, K directly correspond to the Value in Column B
NOTE: there are 17000+ rows in Worksheet 1, and each value in column B is unique (unique email addresses)

Worksheet 2= there is data in each cell in Columns A – P
I would like a formula so that: Whenever a Value in Column B on Worksheet 1 matches any same value in Column N on Worksheet 2, it will deliver the corresponding values from Columns G,H, I, J, K in Worksheet 1 to Columns Q, R, S, T, U within Worksheet 2

NOTE: Another forum suggested VLOOKUP, but I was thinking it's a bit more complicated than that, since the Values in Worksheet 1, Column B (email addresses) are all unique. In Worksheet 2, any given email address may appear multiple times.

[KOKOSEK]

Can you attached any samples file, please?

[MDewane]

I believe I was able to attach an example that corresponds to my question

Worksheet 1= there is data in each cell in Columns A – K
Values in Column B are unique
For any given row, the values in Columns G, H, I, J, K correspond to the Value in Column B

Worksheet 2= there is data in each cell in Columns A – P
Values in Column N are NOT unique

I would like a formula so that:
Whenever the Value in Column B on Worksheet 1 matches ANY same value in Column N on Worksheet 2,
deliver the corresponding values from Columns G,H, I, J, K in Worksheet 1 TO Columns Q, R, S, T, U in Worksheet 2

THANK YOU FOR YOUR HELP

[KOKOSEK]

Into cell Q2 on Worksheet2:

=IFERROR(INDEX('Worksheet 1'!G:G,MATCH('Worksheet 2'!$N2,'Worksheet 1'!$B:$B,0)),"not found")

drag it right to col U and down as much as you need. Should be fine.

[MDewane]

YOU ARE AMAZING! I am grateful. You really helped me out. Like I said, there are 17,000+ email addresses to match in the real file
Have a wonderful day!