T
Tim
=INDEX(Log!AG2:$AG$550,MATCH($B$1,Log!P2:$P$550,0))
I have 1-8 match's for B1 in a Log sheet Column P, starting on Row 2 I
need to match in AG, but what I need to match may be in p2, p3, p7,
and p8, etc, so using relative and absolute and copying down doesn't
work right. It gives me repeat answers when there's a blank row. I
can't change the blank cells, they're based on dates. What can I do to
just get one of each occurance?
($B$1 is on another sheet where my formula is, and I change that value
alot.)
On the first work# I use, p2 and p4 are blank, p3 has what I'm
searching for, but the formula list's what I'm looking for in the 1st
and 2nd row, then #N/A in the 3rd. Wonder why the 1st and 3rd row
aren't #N/A and the 2nd my value?
Thanks, Tim
I have 1-8 match's for B1 in a Log sheet Column P, starting on Row 2 I
need to match in AG, but what I need to match may be in p2, p3, p7,
and p8, etc, so using relative and absolute and copying down doesn't
work right. It gives me repeat answers when there's a blank row. I
can't change the blank cells, they're based on dates. What can I do to
just get one of each occurance?
($B$1 is on another sheet where my formula is, and I change that value
alot.)
On the first work# I use, p2 and p4 are blank, p3 has what I'm
searching for, but the formula list's what I'm looking for in the 1st
and 2nd row, then #N/A in the 3rd. Wonder why the 1st and 3rd row
aren't #N/A and the 2nd my value?
Thanks, Tim