Posted to microsoft.public.excel.worksheet.functions

Lemmesee

external usenet poster

Posts: 31

Shorten Formula

I am sure that this formula can be shorter and take out the repeats.

=IF(ISNA(VLOOKUP(MID(H3,FIND("-",H3)+2,1000),'Movie
List'!B:C,1,FALSE)),IF(ISNA(VLOOKUP(MID(H3,FIND("-",H3)+2,1000),'Janets
Movies'!A:B,2,FALSE)),"","Janet has "&MID(H3,FIND("-",H3)+2,1000)&" Remove
from QUE"),"I have "&MID(H3,FIND("-",H3)+2,1000)&" Remove from QUE")

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
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
Shorten a Formula	Kevin	Excel Worksheet Functions	4	January 30th 06 02:31 AM
Shorten an IF formula	Joker	Excel Discussion (Misc queries)	4	December 10th 05 12:30 PM
Shorten sumproduct formula	Andre Croteau	Excel Discussion (Misc queries)	1	December 11th 04 10:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us