N
NikaM
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
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