Forum Discussion
Validate Part Number in Cell
=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.
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.=IF(ISBLANK(B72),"",IFERROR(VLOOKUP(B72,$B$11:$C$65,2,FALSE),"Invalid Part"))
I entered this formula in C72 and copied it down to C150 and it works in my sheet.
- Sorry, my fault. Sometimes I have to run it through my mind several times before I can describe it correctly. This worked perfect!!! I can't thank you enough. You're the BEST!