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
Bookmarks