Posted to microsoft.public.excel.misc

ben simpson

Posts: n/a

Finding a match and adding to the statement

I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),"Added Holiday(s) For:","")

What I'm wanting to do is to add the information from 'Data Sheet'!B4:B103
to print out after the "Added" statement (the actual name of the holiday
listed). What would be the best way to accomplish this?....Thanks....Ben

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing data, then adding data to the new spreadsheet.. a conund	AndyL82	Excel Discussion (Misc queries)	1	March 9th 06 10:05 PM
MATCH function	David	Excel Discussion (Misc queries)	1	October 1st 05 03:28 AM
adding summed cells in a conditional sumif	Tat	Excel Worksheet Functions	5	June 12th 05 06:09 PM
adding cells that contain formulas that have returned error messag	Daniel R	Excel Worksheet Functions	3	February 21st 05 07:14 PM

All times are GMT +1. The time now is 07:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us