Index and Match Function

		Microsoft Office Forums > Microsoft Excel > Excel
Index and Match Function

FAQ

Thread Tools

Display Modes

05-29-2019, 08:49 AM

mismag

Windows XP Index and Match Function

Office 2016

Novice

Join Date: May 2019

Posts: 3

ArviLaanemets,

I really appreciate you taking time to help.

Quote:

Is this you need?

Yes...This is what I need.
But I am having difficulty in breaking down the formula.

What are "nCalcClass,nCalcGroup,nSaleTerm" in the formula?

And also Can I create the all the tables in one sheet instead of in individual sheets?

Thanks,
Mismag

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Index and Match function with multiple criteria not searching the next record	mushtaqkadar	Excel	3	06-17-2017 12:20 AM
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Index Match Function across different worksheets	shay_mt	Excel	2	04-27-2015 06:04 AM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:18 PM.