I need to change a VLOOKUP formula =VLOOKUP(D566,'Master
Data'!$A$3:$Y$438,25,FALSE)
The 438 should be 1000. Can I change for the whole column or one cell at a
time?
I need to change a VLOOKUP formula =VLOOKUP(D566,'Master
Data'!$A$3:$Y$438,25,FALSE)
The 438 should be 1000. Can I change for the whole column or one cell at a
time?
If you've been good, you might be able to select that column and do:
Edit|replace
what: $y$438
with: $y$1000
replace all
But if there's no data under that table and it won't matter if rows 1 and 2 are
in that table:
edit|Replace
what: $a$3:$y$438
with: $a:$y
replace all
(why worry about extending the range later?)
gswegan wrote:
>
> I need to change a VLOOKUP formula =VLOOKUP(D566,'Master
> Data'!$A$3:$Y$438,25,FALSE)
> The 438 should be 1000. Can I change for the whole column or one cell at a
> time?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks