Comparing varying text in one column to another column and giving results.

[stevepaulbaker]

Hi. Thank you for any guidance or help. I'm not that good with Excel and hope to solve a problem, but need help. Here's what I would like to do - if possible. I have software specs and would like to compare the software specs to any computer specs. I have the ability to run a program to give me all of the computer hardware specs and export to CSV. What I want to do is have a list of preconfigured software specs that I can compare against the same row...So if the hardware spec pulls and dumps this in A1
Windows 7 Professional (64-bit) (Build 7600) I want the formula to know a list of known acceptable software and tell me Pass or Fail.
If A1 says Windows 7 Professional (64-bit) (Build 7600) can a formula just search my list of acceptable software in B1 and if Windows 7 exists in B1 formula show a pass/fail?

Hope that make sense and hope Excel can do this!

Thanks

 

[T. Valko]

Hi. Thank you for any guidance or help. I'm not that good with Excel and hope to solve a problem, but need help. Here's what I would like to do - if possible. I have software specs and would like to compare the software specs to any computer specs. I have the ability to run a program to give me all of the computer hardware specs and export to CSV. What I want to do is have a list of preconfigured software specs that I can compare against the same row...So if the hardware spec pulls and dumps this in A1
Windows 7 Professional (64-bit) (Build 7600) I want the formula to know a list of known acceptable software and tell me Pass or Fail.
If A1 says Windows 7 Professional (64-bit) (Build 7600) can a formula just search my list of acceptable software in B1 and if Windows 7 exists in B1 formula show a pass/fail?

Hope that make sense and hope Excel can do this!

Thanks

Maybe something like this...

A1 = Windows 7 Professional (64-bit) (Build 7600)

G1:G5 = list of keywords to search for

This formula entered in B1:

=IF(COUNT(LOOKUP(1E100,SEARCH(G1:G5,A1))),"Pass","Fail")

 

[stevepaulbaker]

That is excellent. It worked perfectly. Thank you! If I may ask one more question...I have a cell that contains the following C: 74.4GB | F: 15.0GB
I would like to be able to just tell me if C: has more than 10GB or more and write pass and if C: has less than 10GB to Fail. I tried this, but it didn't work out too well....
=IF(B17 <"10GB","PASS", "FAIL")
Thank you again for your help!

 

[T. Valko]

That is excellent. It worked perfectly. Thank you! If I may ask one more question...I have a cell that contains the following C: 74.4GB | F: 15.0GB
I would like to be able to just tell me if C: has more than 10GB or more and write pass and if C: has less than 10GB to Fail. I tried this, but it didn't work out too well....
=IF(B17 <"10GB","PASS", "FAIL")
Thank you again for your help!

Assuming the unit of measure is always GB...

Maybe this...

=IF(LEFT(B17,2)="C:",IF(LOOKUP(1E100,--MID(B17,4,{1,2,3,4,5,6}))>10,"Pass","Fail"),"")

 

[stevepaulbaker]

Wow! Once again you come through and quickly too. Thank you so much for your assistance. The above worked perfectly.

 

[T. Valko]

Wow! Once again you come through and quickly too. Thank you so much for your assistance. The above worked perfectly.

You're welcome. Thanks for the feedback!