In Vlookup function, if
col_Index_no are more than 100 is their any formula or function to take it automatically one after the another? I have to go in each cell cell edit the formula by pressing F2 and put next column no to get the value.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community