Thanks !
On Fri, Apr 17, 2009 at 6:46 PM, Frans2134 wrote:
>
> Shelly,
>
> You could try the following
>
> use the formule:
>
> =VLOOKUP($B20,INDIRECT(Filename&"Pivot-ST'!$B$5:$I$398",8,0)
>
> create a cel named "Filename" and put in here the the name of the
> workbook.
> ''[ABC ltd billing d
Hi Shelly,
Here is your solution, assuming
Last Month Formula : =VLOOKUP($G20,'[ABC ltd billing data - Jan''09
Final.xls]Pivot-ST'!$B$5:$I$398,8,0)
New Formula you need : =VLOOKUP($G20,'[ABC ltd billing data - Feb''09
Final.xls]Pivot-ST'!$B$5:$I$398,8,0)
Solution:
1. Select all the data by press
HI thanks
i m not able to get it. Can you pls. help me by using that formula in excel
sheet and attaching it. So that how its to be used without errors.
Regards,
Shelly
On Fri, Apr 17, 2009 at 6:46 PM, Frans2134 wrote:
>
> Shelly,
>
> You could try the following
>
> use the formule:
>
> =VLOOKUP(
Shelly,
You could try the following
use the formule:
=VLOOKUP($B20,INDIRECT(Filename&"Pivot-ST'!$B$5:$I$398",8,0)
create a cel named "Filename" and put in here the the name of the
workbook.
''[ABC ltd billing data - Jan''09 Final.xls]'
(note the dubbel '' in the text)
For the next month you o
