Posted to microsoft.public.excel.misc

peyman

external usenet poster

Posts: 189

MATCH formula

hi,
I've got a formula like: =match(A6, SHEET2A4:A100,0) and I want to have a
COMMAND BUTTON and instead of A6 in the formula ,I like to have a variable(I
mean a dynamic value) like activecell so that when I press the COMMAND
BUTTON, the formula functions for the cell I'm on.
Is there a way?
Thanks,
Peiman

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
which formula? Match? IF?	shay34	Excel Worksheet Functions	4	November 13th 08 06:01 PM
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw	DS	Excel Worksheet Functions	4	October 7th 06 12:25 AM
How do I display more than one match in a Index/Match formula?	Trish	Excel Worksheet Functions	0	September 26th 05 10:21 PM
MATCH Formula	Sandy	Excel Worksheet Functions	3	August 12th 05 11:42 PM
Lookup Formula - but have a formula if it can't find/match a value	Stephen	Excel Worksheet Functions	11	June 14th 05 05:32 AM

All times are GMT +1. The time now is 12:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us