vlookup and absolute cells

  • Thread starter Thread starter mp
  • Start date Start date
M

mp

Hello all. I am currently using a v-lookup function to
look up values from a table. For all cells, I have the
reference table numbers as absolute cells. For
example: "A$31:G$31". My problem is that I have to
obtain values from a second table for some of the cells.
Is there a way to highlight cells and change just one part
of a formula for those highlighted cells? I really don't
want to go cell by cell to have those cells look in a
different data table for a value.

Thanks!
 
Hi
you may try selecting the cells and use 'Edit - Replace' to search for
your existing range and replacing it with the new range. Make sure you
check the option 'search in formula' within this dialog
 
Back
Top