Column Formula Question

10/27/21
Answered - Pending Review

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?

Answers

  • Jason DuryeaJason 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.

Sign In or Register to comment.