Hello,

My objective is to Vlookup a range of cells at once, and display values in column 2 of the table array in separate rows on a separate sheet, if that makes sense. For example,

excel freeze 1.JPG

How to I produce the formula so that it returns "General Conditions" and "Site Work Misc." in 2 subsequent cells in a separate sheet?

Thanks.