Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup + indirect formula
Hi,
I have dozens of formula like this: VLOOKUP($A22,'sample'!$A$302:$Z$302,2,FALSE), except $A$302:$Z$302 might change like $A$50:$Z$51, picking up from different area. Now I want to replace above formula like this: VLOOKUP($G13,INDIRECT(Fcst&"!$b$20:$z$30"),2,FALSE ) but I won't change area. Because there are so many formula, I want to change them in a batch, I try to use replace (ctrl+R), but it doesn't work because I only want to replace 'sample'!$ with INDIRECT(Fcst&"! I got error message because I can't replace including ") Is there a way to change this formula in a batch? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Verify spelling in a vlookup formula | Excel Worksheet Functions | |||
VLOOKUP Formula | Excel Discussion (Misc queries) | |||
If / Vlookup Formula Help €¦!! | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions |