LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 7
Question If value is true the check column for specific values

Hi

I need a formula to check if a column contains specific values it the column contains a certain value

if column A:A = string "ABC" then check A:A for string "123" & "456". If "456" is missing then display list missing string in cell b2.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count values in column only if value of another column is true MikeB Excel Worksheet Functions 4 September 10th 09 05:19 PM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
Simple Check Box - without True/False values Lisa Excel Discussion (Misc queries) 5 February 13th 07 04:20 PM
how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE JW in Dubai Excel Worksheet Functions 2 July 1st 06 06:34 AM
Check for list of 3 values (alpha) in a column GeeSexAah Excel Programming 2 November 28th 04 11:37 PM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"