Forum Discussion
ElliotDT
Jan 14, 2025Copper Contributor
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.
- Detlef_LewinSilver Contributor
=XLOOKUP(A4,$L$4:$L$25,$M$4:$M$25)
- ElliotDTCopper Contributor
Thank You