IF Function

S

Sandeep Jangra

D'all,
Can "if " search values in a list/range? If yes plz help with an example.
 
S

Stefi

You should give an example of the task!
Regards,
Stefi


„Sandeep Jangra†ezt írta:
 
S

Sandeep Jangra

Dear Stefi,
I have a list of names range A1:A7. Someone gave me a formula
=IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)). What does it mean $A$1:$A$7=$A$10.
 
M

Max

Think its a good idea to start off the learning curve in Excel on the right
footing, eg learn the functionalities of Autofilter & Pivot table ahead of
complex array formulas. See my response to your other posting, where I've
provided you with the easy lead-in details on Autofilter & Pivot table.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
 
S

Stefi

The formula seems to be an array formula checking if name in A10 appears in
any of A1:A7. If yes it returns the row No, if not, it returns FALSE.
To try it select range B1:B7, enter formula and confirm it with
Ctrl+Shift+Enter!

Regards,
Stefi

„Sandeep Jangra†ezt írta:
 
S

Sandeep Jangra

This is not returning row no. showing #value! in both A1:A7 and B1:B10. Plz
correct if any error in this.
 

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

Look up one value and return multiple corresponding values 5
Insert a row after next 100 rows 3
Help on "Define Name" 1
Pivot Table Typical example 2
Newbie Help - IF Yes No Function 0
Insert name and adress from a list in a word document 1
Run macro if conditions meet 1
Excel - Wich Function should I use? 1

Top