matching rows

  • Thread starter Thread starter cape
  • Start date Start date
C

cape

if i have text in row a (help)and text in row b(now) i need a true valu
returned but if i have, row a (help) and row b (later) i need it to b
false. I have 24 combination that need to be true and will have 6
combanations in all. I can nest 8 into a column. Help is alway
appreciated TI
 
Hi
sound like a lookup table is required. Try the following:
1. Create a lookup table for your conditions on a separate sheet (lets
call this 'lookup'). It should have the following layou:

A B C D
1 help helpb helpc
2 later TRUE FALSE FALSE
3 later2 ...
4 later3
5 ...

In this 2D matrix you can assign the return for all of your
combinations

Now on your second sheet you can use the following formula to get the
respective lookup result
=INDEX('lookup'!$B$2;$D$5,MATCH(B1,'lookup'!$B$2:$B$5,0),MATCH(A1,'look
up'!$B$1:$D$1,0))
 
I should have been more clear. if a = b than a true is returned
I will have 24 true statements and a may be the same with a differen
b. or a different and b the same

these are true
Distribution List Add/Remove User
Distribution List Create/Delete List
Group Mailbox Add/Remove User
Group Mailbox Change
Group Mailbox Create/Delete Mailbox
Network Share Add/Remove User
Network Share Change
Network Share Create/Delete Share
Peripheral Move (Logical)
Peripheral Move (Physical)
Public Folder Create/Delete Mailbox
Seat Move (Logical)
Seat Move: within site (Physical)
Software Install (Logical)
Software Install (Physical)

these are false

Peripheral Install
Peripheral Uninstall
Printer/Fax Install
Printer/Fax Move: site to site (Physical)
Remedy Profile Change
Seat Install
Seat Move: site to site (Physical
 
Hi
now I'm confused. I'm not sure what is a and what is b. Also I don't no
what you mean with true is returned.
If your list consists of two different values (e.g. 'Network Share' and
'Change') you may use the lookup methodic i posted in the previous
thread. Use the values
Distribution List
Group Mailbox
Network Share
etc.
as entries in column A (A2:Ann)

and the values
Add/Remove User
Create/Delete List
etc.
as column heading in row 1 (B1:X1)

Now enter the values TRUE/FALSE for each combination. For non valid
combinations you may leave the cell blank or assign a value "N/A".
After doing this use the combination of INDEX/MATCH

Hope this helps. If not mail me an eample sheet of yours and I'll
set-up an example (frank[dot]kabel[at]freenet[dot]de)
 
Back
Top