Hi all
Still very VERY new to VBA so apologies if this is a stupid question!
I've got a formula working in my spreadsheet which is as follows
=INDEX(A2:Q15,MATCH(1,INDEX(($A$2:$A$15="Hours")*($B$2:$B$15="AWH"),0),0),MATCH("July",$A$1:$Q$1,0))
The purpose of the code is to find the row by matching two criteria, then find the column matching a third criteria.
Ultimately what I want to do is return a cell reference, but if I can get it to work returning a value for me, that's a start!
I can get the following working in VBA to check two criteria (one row, one column) but it won't work on the third
It returns an error (Argument not optional) if I try to add a third criterion with the code below
Any ideas? might be a syntax thing or maybe I should start from scratch, all ideas welcome
Thanks
D
Bookmarks