Forum Discussion

ElliotDT's avatar
ElliotDT
Copper Contributor
Jan 14, 2025

Formula Help required - Believe it will be an IF function

Good Afternoon,

 

I am creating a spreadsheet to export data out of an report for part number and quantities. I need a formula that searches for the part number then picks up the quantity next to the part number and fills it out in the box. 

Spreadsheet attached for reference. 

I want the formula to be in column B. Find the part number in column L and pick up the quantity from M and put it into the right box in column B based on the part number in column A.

Resources