Is there an easy way to replace all the 9's to 10's?
Would you consider a Find/Replace?
I have frequently put references or formulas in that argument. If I have several columns to return, I will put the desired column number at the top of my output table, then refer to that in the formula:
blank -- 5 -- 8 -- 9 -- 10 -- 3
lookup1 -- =vlookup($A1,lookup_table,B$1,TRUE) -- copy of B2 -- copy of B2 -- copy of B2 -- copy of B2 (note relative and absolute references)
lookup2 -- copy of B2 -- copy of B2 -- copy of B2 -- copy of B2 -- copy of B2
and so on
I can use formulas for that top row, if I prefer a formula to hand entered values.
I have even included this kind of formula inside of the VLOOKUP() function -- usually involving the COLUMN() or COLUMNS() function as a way of "counting" the current column.
A lot depends on exactly what you want to do.
Bookmarks