Reference Formula and cell reference

		Microsoft Office Forums > Microsoft Excel > Excel
Reference Formula and cell reference

FAQ

Thread Tools

Display Modes

10-15-2024, 08:34 AM

ImAhNoBoDy ImAhNoBoDy is offline

Windows 7 64bit Reference Formula and cell reference

Office 2007

Novice

Join Date: Jan 2012

Posts: 17

I needed up using something similar to this:

https://www.extendoffice.com/documen...al-values.html

=TEXTJOIN(", ", TRUE, IF(COUNTIF(A2, "*"&$D$2:$D$7&"*"), $D$2:$D$7, ""))

The above is just a copy and paste from the site and not what I put in my spreadsheet. I'm putting it here in case I need reference it again.

I got the cell address, I just haven't put everything together. But I think I got what I needed. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determining if an in-text table reference was created with Word's native cross reference feature	scienceguy	Excel Programming	2	10-25-2021 04:44 AM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Formula for reference last non empty cell in row	npn321	Excel	10	02-22-2017 11:42 PM
Issue with a dynamic cell linking/reference formula	raravind82	Excel	2	10-26-2016 04:16 AM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM