How to find a value in an array?

[Raschy]

Hi, I have the following functions:

=IF(('Input Sheet'!$D$2:$D$250='Supplier Input'!A6)*(MONTH(H$2)=MONTH('Input Sheet'!$Q$2:$Q$250)),IF('Input Sheet'!$E$2:$E$250>0,IF(('Input Sheet'!$Q$2:$Q$250-'Input Sheet'!P4:$P$250)={29,30,31},VLOOKUP($A$6,'Input Sheet'!D:M,ROWS('Supplier Input'!$H$7:H9)+1,FALSE),"Nem teljes számla!"),"Credit Note!"),"Nincs számla!")

The problem is with the 'Input Sheet'!$D$2:$D$250='Supplier Input'!A6
part. What I want to do is to find the Value in A6 in the Column D2:D250, and work with that row, in which it is found.
How can I do this?

Thank you for your help,

 

[Gilliam]

=MATCH('Supplier Input'!A6, 'Input Sheet'!$D$2:$D$250,0)+1
should be the row number

 

[Raschy]

Hello, thanks for the reply. I have another question, though: How can I compare a value to an array of values, and get a TRUE If the value is in fact in the array? For instance: 5={1,2,3,4,5} would give a TRUE. How can I do that?