You can't have an Excel function replace the values in the cell.You could use
VBA, but it would be easier to simply use VLOOKUP.
In Cell B21, put:=VLOOKUP(C21,$A$10:$B$17,2,FALSE)Then copy this down to row 29.
HIghlight the cells and ctrl-CThen, right-click cell C21 and Paste Values.
Paul
Dear All,
Attached file has a small exercise done on INDEX function , Presently cells
C21 to C29 has numbers, Instead of that how can I replace those cells with
the names of the cities given in the table and continue using INDEX
function ? Do I need to do this with a macro ?
Note this is part of a
