LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default Get location of match in another worksheet

"Workbook A/worksheet A" contains a reference cell with a date (formatted
date number). I need a formula for this worksheet that gives the cell
address in range B1:G65 of "workbook B/worksheet C" that matches the contents
of the reference cell. Some of the cells in B1:G65 of workbook B/worksheet C
contain date numbers and one will match. I will use that address to import
data from cells below the matching cell.
 
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
Reference Worksheet Location from web rKeen Links and Linking in Excel 0 October 22nd 09 12:21 AM
Row to Be shifted to another location in the same Worksheet Misho Excel Discussion (Misc queries) 0 May 21st 09 05:11 PM
printing data from different location in same worksheet tikchye_oldLearner57 New Users to Excel 2 March 29th 06 04:29 PM
How do I freeze more than one location on my worksheet? Melody Excel Worksheet Functions 3 January 29th 06 07:41 AM
How to move location of chart within a worksheet? [email protected] Excel Discussion (Misc queries) 1 May 17th 05 11:38 PM


All times are GMT +1. The time now is 07:55 AM.

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"