I

2. Re: LOOKUP formula (Excel)

Something to add in the conditions section (cell array D8:K21) is basically a matrix. if there is a 1 anywhere in this matrix it corresponds to the system on the same row and the condition labled above.

3. Re: LOOKUP formula (Excel)

I tried understanding the formula but figured this might be easier, does this attachment work>

4. Re: LOOKUP formula (Excel)

Not sure exactly what you are after but here is a try
1) in B10:
=INDEX(\$D\$1:\$M\$1,MATCH(A10,\$D\$2:\$M\$2,0))
Hlookup expects the lookup value in the top row of the range
[You could reverse rows 1 and 2 and use:
=HLOOKUP(A10,\$D\$1:\$M\$2,2,0) in D10]

2) not clear at all at what you want. How is this:
=IF(OR(AND(D8<\$P\$2,\$P\$2<D9,D10=1),AND(E8<\$P\$2,\$P\$2 <E9,E10=1),AND(F8<\$P\$2,\$P\$2<F9,F10=1),AND(G8<\$P\$2, \$P\$2<G9,G10=1),AND(I9=\$P\$4,I10=1)),1,"")

Steve

5. Re: LOOKUP formula (Excel)

Under system stage I have used this formula which doesent work
=IF(OR(B19<\$B\$2,\$B\$2<C19,\$B\$4=D19,\$B\$3=E19),VLOOKU P(A19,\$A\$2:\$B\$15,2,FALSE)

6. Re: LOOKUP formula (Excel)

Try this
=IF(AND(B21<\$B\$2,\$B\$2<C21,\$B\$4=D21,\$B\$3=E21),INDEX (\$A\$6:\$A\$15,MATCH(A21,\$B\$6:\$B\$15,0)),"")
and drag it down

7. Re: LOOKUP formula (Excel)

Yes sorry Patrick and Steve and Thanks for your Time. I have attached a better example of what I am trying to achieve. I have added comments to the worksheet to describe it.

Hopefully this is clearer.

Thank You

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•