| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a value from 1 column in another column on another sheet
I need to see if the value of cell in a column on sheet1 is also in a column
on sheet2, if it is I want it to return a value of TRUE. Is there a function I can use for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find a value from 1 column in another column on another sheet
=COUNTIF(Sheet2!A:A,A2)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gluefoot" wrote in message ... I need to see if the value of cell in a column on sheet1 is also in a column on sheet2, if it is I want it to return a value of TRUE. Is there a function I can use for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find common text in cell in column in sheet then return total amou | Excel Worksheet Functions | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| Find next column in sheet | Excel Discussion (Misc queries) | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
| Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
Linear Mode
