Macro or Function to Change the value of lookup_value

[Schauvin]

example



=VLOOKUP(Sheet2!$V$12,$BN$29:$BO$168,2,FALSE)
=VLOOKUP(Sheet2!$X$12,$BN$29:$BO$168,2,FALSE)

I have literally hundreds of these, I need to change the Sheet2!$v$12 to
Sheet2!$v$21, for about 80 of them, then add 9 again for another block, can someone give me a hand or point me in the right direction for a macro to just change the row number in that function for the Lookup_value?
<table border="0" cellpadding="0" cellspacing="0" width="66"><tr height="17"><td class="xl22" style="height: 12.75pt; width: 50pt;" align="center" width="66" height="17">
</td> </tr></table>

 

[Jonmo1]

Welcome to the board...

You could just Click Edit - Find/Replease

Find VLOOKUP(Sheet2!$V$12
Replace with VLOOKUP(Sheet2!$V$21

 

[jmthompson]

Did something similar to this last week.
Select the range for your first update

Find =

Replace with " " (space)


Find VLOOKUP(Sheet2!$V$12

Replace with VLOOKUP(Sheet2!$V$21


Find " " (space)

Replace with =


Find =
Replace with =

 

[Schauvin]

Thanks for the welcome!

I will give the find replace a shot, I think I'm going to run into an issue because of the column letter skips a letter every line down, and there is literally hundreds of these.

Thank you a lot for the suggestions

 

[Schauvin]

Yeah, thanks for the suggestions, but I'm finding it a lot easier to just do it by hand, with every single line being different in one letter, and the before what I want to change.

Thanks though!