another issue with vlookup

A

Arain

i have another issue i just came across. the sheet its taking the data also
change i mean the first column looks in sheet name May second column looks in
sheet name June. when i copy paste it copies may all over the place. is
there a way to change it in the formula. its sounds painful to go in and
change the sheet name from may to june for 10000 lines. can someone please
help
 
J

JLatham

Select the cells/columns you need to change month name to and use Edit |
Replace with the "look in formulas" option. Find "May", replace with "June"
 
P

Pete_UK

I haven't seen your other post, but if you highlight the cells withthe
formula in (presumably using May!range for the table), then CTRL-H for
Find & Replace:

Find What: May!
Replace with: June!

then click Replace All.

Hope this helps.

Pete
 
Top