Posted to microsoft.public.excel.misc

ansar ak

external usenet poster

Posts: 1

Copy a formula using Vlookup

Dear all,

I have a sheet with some formulas, i need the same formulas in the new
sheet.

Eg: -
A1 A2
A3 A4 A5 A6
Code Customer Name Oct 11 Sep 11 Aug 11 Total
CAA001 ABUDHABI HOSPITALITY CO. 11,456 8,422 28,063 =sum(A3:A5)

can i able to copy only formula (A6) with reference to the colomn A1
using Vlookup or any other formula to the new sheet

Ansar

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup formula copy	Confusicous	Excel Discussion (Misc queries)	4	September 10th 09 08:33 PM
Copy part of VLOOKUP formula?	absfl	Excel Discussion (Misc queries)	4	April 19th 09 08:08 PM
How do i copy a vlookup formula into other cells going right	km440	Excel Worksheet Functions	1	December 12th 08 10:53 AM
Vlookup Copy Formula	Joe K.	Excel Worksheet Functions	2	November 19th 08 03:34 PM
Copy VLOOKUP Formula	EMarre	Excel Discussion (Misc queries)	4	October 21st 05 04:05 PM

All times are GMT +1. The time now is 10:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us