find a value based on two conditions in a table

		Microsoft Office Forums > Microsoft Excel > Excel
find a value based on two conditions in a table

06-02-2022, 10:09 AM

p45cal

Windows 10 find a value based on two conditions in a table

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

try in C2:
=INDEX($F$3:$L$6,MATCH($A2,$E$3:$E$6,0),MATCH($B2, $F$2:$L$2,0))
copy down.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to make sum based on multiple conditions, HELP!	ilsel	Excel	3	11-15-2017 02:03 AM
Find and Replace rows in a table based on bold text.	OfficeAssociate99	Word VBA	4	07-26-2017 07:20 AM
Find and Replace rows in a table based on bold text.	OfficeAssociate99	Word VBA	2	07-26-2017 06:32 AM
Index to return value based on 2 conditions	george batshon	Excel	2	01-28-2017 05:11 AM
How to Subtract value in table, based on two different conditions	nitemath2	Excel	1	06-19-2015 01:28 AM

Other Forums: Access Forums

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