Posted to microsoft.public.excel.misc

Secret Squirrel Secret Squirrel is offline

external usenet poster

Posts: 172

Change value after lookup

I have two worksheets in my file. I have a value in sheet1 in cell AN2 that I
need to lookup on sheet2 in column AF. When it finds a match I then need to
change the value in column N on Sheet2 for the row it found the value in. How
can I write vba code to fire this code?

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
Lookup and Change Values	Jeff Gross	Excel Worksheet Functions	3	March 20th 08 03:16 PM
V Lookup Not working since change	Pammi J	Excel Discussion (Misc queries)	3	July 13th 07 11:04 AM
How to change lookup references	Guy Yeakley	Excel Worksheet Functions	1	January 25th 06 02:24 PM
Lookup and Change	rollover99 via OfficeKB.com	Excel Worksheet Functions	2	December 30th 05 01:17 AM
LOOKUP: change referenced spreadsheet	Barb	Excel Discussion (Misc queries)	5	November 2nd 05 12:08 AM

All times are GMT +1. The time now is 06:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us