A formula to look for a value in a blok (eg E1:J10) data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a formula in Excel 2003 /2007 that wil search through a blok
of data (say C1: J10) for a value (could by alfa-nomeric) entered into a cel
(say A5) Thus look in C1 : J10 for the value entered in A5 and return true if
found or false if not. Alternatively perform "X" if true else "Y"
Thank You
 
I'm don't know what you mean by "perform". Here are some examples:

=IF(COUNTIF(C1:J10,A5)>0,TRUE,FALSE) If A5 is in the values in the range
C1:J10, TRUE is returned, else FALSE.
=IF(COUNTIF(C1:J10,A5)>0,"Yes, the value is in the range","No, the value is
not in the range") This is self explanatory.
=IF(COUNTIF(C1:J10,A5)>0,A5,0) This returns the value in A5 if A5 is in
the range C1:J10 else it returns 0.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Complex Q 2
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns 19
returning a text value using a formula 1
Combine 2 Data Validations Q 5
Adding to a formula thru out a worksheet 2
Function to Return a Date Value Q 4
Create a formula by joining text and the value from a formula 3
How do I set a formula, that add next cell reference in a Formula 2

Back
Top