Auto populate with formula; vlookup, if blank etc.

[Harley78]

I have a Freight workbook with parts listed when they came in and what is due to arrive. Column N is "Delivered date" and Column P is Carrier info.
I have a Balance Due Report workbook and want to do a vlookup (in Cel ")AR33"so it will auto populate using the Freight worksheet Column P (carrier info).

I am stumped how to make it look at the Balance Due Report and freight worksheet for the Same Part Numbers on both worksheets and make it look at column N (first Blank row) on Freight workbook and have it input the data using column P from Freight workbook.

Formula to be entered in the Balance Due Report (Column/Row: AR33)
I see it as " If Part # (Row 33 Column C) on Balance Due Report and Freight Report (Column A)are the same then find the first blank (under the part number) on the freight report and input what is in column P from the Freight Report into Balance Due Report (Column/Row: AR33). Not sure how to write it.

I hope I stated it clearly (least in my head I understand) Again, many thanks as always.

Bill

 

[Roderick_E]

This sounds like it needs to be macro and most likely use

result = application.index(rangeofdatatoreturn,application.match(partnum,partnumrangetomatch,0))

triggered by a command button perhaps?