Hi,

i have a spreadsheet with data:

document no. | product

I would like the Excel to compare cells a:a with cell f4 in sheet 2.
I need Excel to display all products where cell 'a' is the same as f4 in
Sheet2.

When i use =IF($F$4=sheet1!A2;sheet1!b2) it displays:
false
false
ananas
banana
false

I would like Excel to display only cells with TRUE / product name, so I
would get:

ananas
banana

Thanks,
Nika

=IF($F$4=sheet1!A2;sheet1!b2;"")

"NikaM" <(E-Mail Removed)> wrote in message
news:18BFB4BA-BB19-4C7E-87F5-(E-Mail Removed)...
> Hi,
>
> i have a spreadsheet with data:
>
> document no. | product
>
> I would like the Excel to compare cells a:a with cell f4 in sheet 2.
> I need Excel to display all products where cell 'a' is the same as f4 in
> Sheet2.
>
> When i use =IF($F$4=sheet1!A2;sheet1!b2) it displays:
> false
> false
> ananas
> banana
> false
>
> I would like Excel to display only cells with TRUE / product name, so I
> would get:
>
> ananas
> banana
>
> Thanks,
> Nika