Hi Folks
Yet another one of these.
I have attached a workbook to explain my requirement.
Cheers
Hammer
Hi Folks
Yet another one of these.
I have attached a workbook to explain my requirement.
Cheers
Hammer
on cell bz3
Note: array formula, use CTRL+SHIFT+ENTERPlease Login or Register to view this content.
Click (*) if you received helpful response.
Regards,
David
Hi David
Many thanks for the response.
Unfortunately the formula is not working correctly as it has returned the value 1 into the first 5 rows.
I am just going to make a new example sheet with color coding for each step which should assist in understanding what I am trying to achieve.
Back soon.
Cheers
Hammer
Updated workbook
=IFERROR(IF(C2="","",MATCH(1,INDEX((OFFSET(HHCP!$A$1,2,MATCH(BZ$1,HHCP!$1:$1,0)-1,137,1)=$C2)*(OFFSET(HHCP!$A$1,2,MATCH(BZ$1,HHCP!$1:$1,0),137,1)=$H2)*(OFFSET(HHCP!$A$1,2,MATCH(BZ$1,HHCP!$1:$1,0)+1,137,1)=$G2)*(OFFSET(HHCP!$A$1,2,MATCH(BZ$1,HHCP!$1:$1,0)+2,137,1)=$D2)*(OFFSET(HHCP!$A$1,2,MATCH(BZ$1,HHCP!$1:$1,0)+3,137,1)=INDEX($A2:$BY2,MATCH(BZ$1,$A$1:$BY$1,0))),0),0)>0)*1,"")
Try this in BZ2 and copy across
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I think you have nailed it Siva! (I suspect you knew that though )
I'll just xfer to my actual Workbook before marking the thread as solved.
Back soon
hi hammer, i never seen this before
your booth sheets have some common headings, so i thought that you are looking for it. here my guess was correct, that's all
Well I really liked your 'guess'
Your time, effort, expertise and 'guess' are greatly appreciated!
Cheers
Hammer
Hi Siva
Just one further assist please. I need to extend the Cols in HHCP to and including Col KI so need to know what to change in the formula to make that work.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks