How to lookup a corresponding cell on another sheet and bringing over multiple columns?

[anoble1]

I have an Excel sheet with lots of part numbers. I have another sheet that has part numbers with descriptions and 5 other columns I need.
A vlookup grabs 1 column. Is there something I can use that will do the vlookup on the part but allow me to choose multiple columns to bring over?

[mcmahobt]

Upload a sample workbook to get specific help

[skywriter]

Look at the two formulas in column F. The first one F2 could be used to bring all the information into one cell, but you can't do anything with the dollar amount, such as math. The formula in F3 is written so that the information is in different cells, but it can be copied from left to right without writing a new formula in each column.

[anoble1]

Attached is a Test sheet. I want to bring over the "Master" sheet values. I would like to look for the part number in the Master and return columns B, C, D.
Is that possible? I know i can do one column at a time, but I get these all the time.
Thanks,

[mcmahobt]

Paste into B1 of your EDIT sheet in your workbook example, and drag over and down to fill:

Please Login or Register  to view this content.

[anoble1]

Paste into B1 of your EDIT sheet in your workbook example, and drag over and down to fill:

Please Login or Register  to view this content.

That formula worked very well. Thanks. I was thinking some kind of vlookup, but I like that better.!