Are you looking for this result?
Q7=IFERROR(INDEX(InputOutsideLines!$T$19:$AB$42,MATCH($H$7,InputOutsideLines!$T$19:$T$42,0)-1+Q$2,MATCH(Q1,InputOutsideLines!$T$18:$AB$18,0)),"")
Are you looking for this result?
Q7=IFERROR(INDEX(InputOutsideLines!$T$19:$AB$42,MATCH($H$7,InputOutsideLines!$T$19:$T$42,0)-1+Q$2,MATCH(Q1,InputOutsideLines!$T$18:$AB$18,0)),"")
Hi Raul
Not quite there - formula is creating Bait Station numbers which aren't in the data schedule i.e. 5
Seems to allocate as Bait station # the row number in data schedule
Also 1st Match (cell H7) not being recognised - data from table should only extract from column T that matched cell H7 (i.e. "1n")
cheers
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks