Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 16th 15, 11:12 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2015
Posts: 4
Default Excel INDIRECT or CONCATENATE ?

I am struggling with either INDIRECT or CONCATENATE in (Excel 2003 or 2007 I have access to either).

Using a multi sheet workbook, every month I have to go through each sheet and change the row reference in a cell formula. Thought INDIRECT or CONCATENATE could generate a volatile reference for me.

If in Sheet 1 (Sheet Name FOW) cell A1 I put the current month row reference (same on each sheet eg 23) and on each sheet in cell A2 I put that sheets column reference (they vary - AB, BT, CZ etc.), then a cell in each each sheet should be able to have a volatile cell lookup based on current sheet cell A2 concatenated with Sheet1 cell A1

If I put text in the cells =CONCATENATE(A2,FOW!A1) I can get the CONCATENATED reply (eg JohnDoh) but cannot workout how to get this into a formula.To return the cell value. Where FOW!A1 is 23 and A2 is CZ. The simple cell reference is =CZ23.

Each month I go through each sheet changing =CZ23 to =CZ24 then =CZ25 etc, and on the next sheet =BT23 to =BT24 then =BT25 and so on.

Any assistance appreciated.

Paul
PS Sure it cannot be as difficult as I am making it.

  #2   Report Post  
Old April 16th 15, 10:52 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 7
Default

Mă giảm giá Lazada [/color]Mă giảm giá Lazada giúp giảm thêm 100.000 VNĐ trên đơn hàng của bạn kể cả các mặt hàng bạn đang mua đă được giảm giá, nhấp vào đây để xem coupon ...


Reply
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
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? [email protected] Excel Worksheet Functions 1 November 13th 13 07:22 PM
INDIRECT and CONCATENATE in Defined Name BillCPA Excel Discussion (Misc queries) 2 April 22nd 09 04:50 PM
Indirect/Concatenate query Fred Excel Programming 3 May 2nd 06 02:11 PM
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow Excel Worksheet Functions 6 July 6th 05 03:04 AM
Indirect, Concatenate, & ? JEFF Excel Worksheet Functions 7 June 21st 05 08:17 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017