Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-05-2012, 10:24 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Very simple formula needed! Windows 7 32bit Very simple formula needed! Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Welcome to the forum.

Are you entering =IF(B3:B13=$L$1,A3:A13,"") into an array range? I think it would help us if you mocked up an example spreadsheet and attached it to the thread for us to see. If you're asking for what I think you're asking for then, yes, it is possible to do it with formulas but it is not simple and there are better alternatives. I'll reserve my recommendation until I'm 100% clear on exactly what you need.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Very simple formula needed! It has to be simple...formula ClearSkies Excel 1 03-04-2011 01:06 PM
Simple or what? nebb Publisher 0 09-23-2010 07:00 AM
Simple template kieransymes Word 0 03-08-2010 02:13 AM
Simple formulas den hobbelder Word 1 02-26-2010 01:53 PM
Excel formula needed. Rod Excel 1 08-03-2009 06:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft