Column Formula Question

Ben Maritato

Is it possible to convert a cell formula to a column formula if it references a different sheet?

Here is the formula in question:

=VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false)

Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet. I am currently unable to convert this formula to a column formula and was wondering why?

Jason Duryea

What are you receiving for an error message or issue indicating that it is not allowing you to convert it? You could also try using =INDEX(MATCH()) which is the recommended alternative to VLOOKUP(). It creates fewer cell references.