Forum Discussion
Solved
Validate Part Number in Cell
Hello, I have a spreadsheet with cells B11 through B65 with a 4 digit part number. Example, 4112. If a user enters a part number in cells B72 through B150 but that part number is not a valid par...
=IFERROR(VLOOKUP(B72,$B$11:$C$65,2,FALSE),"Invalid Part")
This works in my spreadsheet. Unfortunately from your initial post i didn't understand that there are part descriptions in range C11:C65 which you want to retrieve.
=IFERROR(VLOOKUP(B72,$B$11:$B$65,1,FALSE),"Invalid Part")
It works in my spreadsheet if i enter this formula in cell C72 and copy it down to cell C150. An entry in cells B72:B150 either returns the item number or Invalid Part.
- This works however when its a valid part number it does not pull in the part number description in the corresponding cells. Cells C11 through C65. It just pulls in the part number now.
If I type in part number 4125 in cell B72 and hit enter, if its a valid part it will display the full part number description that is listed in cell C63 if not, "Invalid Part".=IFERROR(VLOOKUP(B72,$B$11:$C$65,2,FALSE),"Invalid Part")
This works in my spreadsheet. Unfortunately from your initial post i didn't understand that there are part descriptions in range C11:C65 which you want to retrieve.
- Sorry one more thing. If Cells B72 through B150 have nothing in it, (no part number added) then the adjacent cells C72, etc. will be blank.
Ex. If I enter part number 4126 in cell B72 it displays the full part number, if not a valid part it gets the "invalid part" but if no number at all in B range then the C column is empty/blank until something is added.
