Pulling mutliple lines into a formula

[tysterdude]

I am trying to create a function that when I enter a part number in Cell B17-B29 it will match that part # to "sheet1" and pull the pricing and description. I have all the pricing for everything on the Sheet 1 attached to this main form. For example the equation I put in was only to test the first line, I did IF(B17=Sheet1!D2,Sheet1!F2*A17), this matches the part# and pulls the pricing thats in the same row and multiplies it based on the quantity I entered. I have another equation for the description column that simply pulls E2 instead of F2 and no multiplying since its text. So basically I need something like IF(B17=Sheet1!D2:D100, pull whatever row that is but column F). I have no idea if this is even a thing that's possible but I imagine there's a function I just don't know about. Attached are images to help you see what I'm poorly describing.

 

[jtakw]

Hi,

For C17 copied down:

=IF(B17="","",VLOOKUP(B17,Sheet1!D$2:E$10,2,0))

For D17 copied down:

=IF(A17="","",VLOOKUP(B17,Sheet1!D$2:F$10,3,0)*A17)

 

[jtakw]

For D17 copied down:

=IF(A17="","",VLOOKUP(B17,Sheet1!D$2:F$10,3,0)*A17)

Oops, I meant G17 copied down.

 

[tysterdude]

Thank you so much!!!

Oops, I meant G17 copied down.

 

[jtakw]

You're welcome, thanks for the feedback.