Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Creating function to insert data based on criteria

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tami - 18 Aug 2006 22:37 GMT
I have a spreadsheet with three columns and numerous rows.  If Column B meets
a certain criteria, and Column C meets a certain criteria, I'd like the
reference number in Column A to be inputted into a different part of the
spreadsheet.  How do I do this?
Reply to this Message
Dave F - 18 Aug 2006 22:42 GMT
=IF(B1=Criteria,if(C1=Criteria,A1,""))
Signature

Brevity is the soul of wit.

> I have a spreadsheet with three columns and numerous rows.  If Column B meets
> a certain criteria, and Column C meets a certain criteria, I'd like the
> reference number in Column A to be inputted into a different part of the
> spreadsheet.  How do I do this?
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.