Returning value based on multiple crtiteria

		Microsoft Office Forums > Microsoft Excel > Excel
Returning value based on multiple crtiteria

03-06-2017, 04:58 PM

jeffreybrown jeffreybrown is offline

Windows Vista Returning value based on multiple crtiteria

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

Try...

=INDEX(Sheet1!$B$3:$AF$38,MATCH($U$8,Sheet1!$A$3:$ A$38,0),MATCH($H$5,Sheet1!$B$2:$AF$2,0))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating multiple spreadsheets based on text	ksigcajun	Excel Programming	63	04-17-2015 12:17 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Multiple Userforms Displaying Different Content but Returning Same Content?	marksm33	Word VBA	1	02-24-2014 06:17 PM
Incrementally returning a value based on relative running totals	salconflu	Excel	1	02-05-2014 10:47 AM
Multiple Standard Rates Based on Location	JohnTurner	Project	3	01-23-2014 12:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.