Microsoft Office Forums - View Single Post - Returning value based on multiple crtiteria

Thread: Returning value based on multiple crtiteria

View Single Post

Old

03-06-2017, 04:58 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

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))

Reply With Quote