Hi Chuch S48,

Welcome to ExcelFox !!

The syntax for VLOOKUP seems to be incorrect. Try LOOKUP.

If it doesn't work, attach the workbook so that we can have a detailed look.