Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do I need Findnext? Not sure how
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with FindNext error | Excel Programming | |||
Findnext | Excel Discussion (Misc queries) | |||
Using 'Find' and 'FindNext' in vba | Excel Programming | |||
FindNext | Excel Programming | |||
FindNext | Excel Programming |