Thanks for the reply folks. As suggested how do i set up a Vlookup formula using a table? The returned data and cell references will remain the same.