if

[tommyboy]

I have this but cant add any more due to max being 7

=IF(ID!C3=50229,ID!E3,IF(ID!C4=50229,ID!E4,IF(ID!C5=50229,ID!E5,IF(ID!C6=50229,ID!E6,IF(ID!C7=50229,ID!E7,IF(ID!C8=50229,ID!E8,IF(ID!C9=50229,ID!E9,IF(ID!C10=50229,ID!E10,))))))))

i need to enter this

=IF('Import Data'!C3=50229,'Import Data'!E3,IF('Impor
Data'!C4=50229,'Import Data'!E4,IF('Import Data'!C5=50229,'Impor
Data'!E5,IF('Import Data'!C6=50229,'Import Data'!E6,IF('Impor
Data'!C7=50229,'Import Data'!E7,IF('Import Data'!C8=50229,'Impor
Data'!E8,IF('Import Data'!C9=50229,'Import Data'!E9,IF('Impor
Data'!C10=50229,'Import Data'!E10, IF('Import Data'!C11=50229,'Impor
Data'!E11, IF('Import Data'!C12=50229,'Import Data'!E12, IF('Impor
Data'!13=50229,'Import Data'!E13, IF('Import Data'!C14=50229,'Impor
Data'!E14, IF('Import Data'!C15=50229,'Import Data'!E15, IF('Impor
Data'!C16=50229,'Import Data'!E16, IF('Import Data'!17=50229,'Impor
Data'!E17, IF('Import Data'!C18=50229,'Import Data'!E18, IF('Impor
Data'!C19=50229,'Import Data'!E19, IF('Import Data'!C20=50229,'Impor
Data'!E20,""))))))))))))))))))

I know i can use VLOOKUP or CONCATENATE but is there a way to do thi
in vb that is more simple


any ideas???????

 

[JE McGimpsey]

How about:

=INDEX(ID!E3:E10,MATCH(50229,ID!C3:C10,FALSE))

 

[tommyboy]

nice 1

thanks alo