Record Matching

		Microsoft Office Forums > Microsoft Excel > Excel
Record Matching

FAQ

Thread Tools

Display Modes

08-20-2014, 03:36 AM

Pecoflyer

Windows 7 64bit Record Matching

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Try this in A2

Code:

=INDEX($C$1:$K$1,SUMPRODUCT((COLUMN($C$2:$K$17)*($C$2:$K$17=$B2)))-COLUMN($C$2:$K$17)+1)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pge numbers on pages and in TOC not matching	Marshalee	Word	2	04-23-2014 10:40 AM
Need help matching text to the Character Map	Bobosmite	Word	1	07-12-2012 08:12 AM
matching fileds in mail merge	estroh	Mail Merge	3	01-19-2012 03:43 PM
avoid duplicete record and merge the record with the existed record	hemant.behere	Excel	0	01-10-2012 02:53 AM
How to merge matching cells vertically?	Odiseh	Excel	1	01-02-2010 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:21 AM.