compare values
 

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

compare values
 

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

"NikaM" wrote in message
...
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