Share via

how to enable column number in vlookup in mac book pro

Syam Kumar 0 Reputation points
2023-12-11T13:07:49.1233333+00:00

i have been using excel 2019 in my mac book pro. I am new to the mac book. when i tried to do vlookup , i was stopped at column index number because there were no column number showing in the excel. after lot of google everyone says that we need to count the column number manually only. and that will be not posssible. pls help on how to know the column number for vlookup

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Barry Schwarz 3,746 Reputation points
    2023-12-11T18:30:30.24+00:00

    The column index number is a relative number based on the range you specify. For example, if your range is D1:G27, then column F would be specified as 3.

    If your range is so wide that figuring out the relative column is too complicated, the you could specify the third argument with a simple formula. In my example, you would use

    VLOOKUP(3.14159,D1:G27,CODE("F")-CODE("D")+1)

    If you really want to see column numbers instead of letters, go to File->Options->Formulas and select the "R1C1 reference style" option

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.