Compair two pair of cells: function usage

		Microsoft Office Forums > Microsoft Excel > Excel
Compair two pair of cells: function usage

01-27-2023, 08:57 AM

mrgramm

Windows 10 Compair two pair of cells: function usage

Office 2021

Novice

Join Date: Jan 2020

Posts: 7

Try =INDEX(Sheet11!$C$1:$C$3,MATCH(Sheet10!A1&Sheet10! B1,Sheet11!$A$1:$A$3&Sheet11!$B$1:$B$3,0))
Sheet11 is your sheet B and sheet10 is your sheet A

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SubTotal function counts the blank cells with formula	LearnerExcel	Excel	3	12-29-2019 04:54 AM
Help with Index Function to Select Range of Cells	bretyuin	Excel	1	02-24-2016 05:11 AM
Linking specific cells in Excel to function with MergeField?	Fabulist	Word	0	02-17-2016 02:19 AM
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
mapping from token to text/number pair	JettyGuy	Word	0	08-13-2011 10:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 PM.