Hi guys
Here's a tuff one, for me anyway.
I have this file attached with lot more info on the right, but i wanna test only the second column and give the result of the first column.
What i want is:
On cell D2 i insert the value 2 wich is the criteria from column B.
The result should be:
on cell D3 the value 001
on cell D4 the value 005
on cell D5 the value 006
on cell D6 the value 008
and so on...
Many thanks for all your replies
Best regards
Pedro
In D3:
=IFERROR(INDEX($A$2:$A$100,MATCH(D$2,$B$2:$B$100,0)),"-")
In D4 - array entered (press Ctrl+Shift+Enter instead of just Enter):
=IFERROR(INDEX($A$2:$A$100,MATCH(D$2,IF(COUNTIF(D$3:D3,$A$2:$A$100)=0,$B$2:$B$100),0)),"-")
Copy D4 downward as far as required.
Steve D. a.k.a. Stephen Dunn
Hello Stunn
The formula is giving an error. could you please send me the formula inside the file i've send you?
Tks a lot
Pedro
Here you go.
Great job
Many thanks
Pedro
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks