EDIT: per your upload the Column reference in the VLOOKUP should be 2 and not H9, also it is not an Array formula - commit with ENTER as normal (not CTRL + SHIFT + ENTER)