| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two values | Excel Discussion (Misc queries) | |||
| Compare Values | Excel Worksheet Functions | |||
| Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
| compare a few values | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Linear Mode
