Populate a cell using 2 reference points

		Microsoft Office Forums > Microsoft Excel > Excel
Populate a cell using 2 reference points

FAQ

Thread Tools

Display Modes

06-22-2017, 10:25 PM

xor

Windows 10 Populate a cell using 2 reference points

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

I am not quite sure what you are asking about.

I don't know even the most basic about Mac, but if it is the ampersand that is a problem you may be able to use the function CONCATENATE instead.

=INDEX(C3:C219,MATCH(CONCATENATE(D1,D2),INDEX(CONC ATENATE(A3:A219,B3:B219),),0))

If it is something else you mean, please explain.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word - Table of contents with multiple reference points	dc2407	Word	5	04-25-2017 02:25 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
Using Cell Values in Active Sheet to Populate Path to External Reference Link	wowcrofty	Excel	4	12-19-2016 12:29 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.