LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Psychlogic
 
Posts: n/a
Default can vlookup place results in a different box than the formula?

If i write a vlookup formula in cell F1, can I somehow have the result show
up in f2. Also, can I have the result be a value. My need is to generate
monthly reports based on a separate Excel file and send them to someone.
When you separate the report from the original file, "help" pops up asking if
you want to update the file and that is a nusisance.

If possible, please reply to

thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Excel version 2002 biz Excel Discussion (Misc queries) 0 September 7th 05 01:07 AM
Some formula results will not show up in the cell Space Elf Excel Worksheet Functions 3 August 1st 05 01:26 AM
put formula results into a different cell if it is empty PutFormula Excel Worksheet Functions 2 February 11th 05 03:31 AM
Cells displays formula, not results synaptic5150 Excel Worksheet Functions 1 January 19th 05 09:56 PM
How do I use Range Names listed in a VLookup table in a formula? Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 10:11 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"