Look Up Value

amna77 · May 15th, 2002, 06:30 AM

Hi,
I want to create a macro for look up values.
I have two sheets. in sheet1 I have all data, and in sheet2 I have data only in column A. In short sheet1 and sheet 2 column A are kind of same, becasue they both have index number. now I want to create a macro so when ever I run that macro it should fill the sheet2. where ever those index number are same in sheet1, then plug in the value in column C in sheet 2.
Please help me out here.
Thanks.

Dexter · May 15th, 2002, 06:44 AM

Unless I'm missing something, this sounds like your problem would be best addressed using lookup formulas in sheet 2 without the need to create a macro.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 06:30 AM	#1
amna77 Board Regular Join Date: May 2002 Posts: 251	Hi, I want to create a macro for look up values. I have two sheets. in sheet1 I have all data, and in sheet2 I have data only in column A. In short sheet1 and sheet 2 column A are kind of same, becasue they both have index number. now I want to create a macro so when ever I run that macro it should fill the sheet2. where ever those index number are same in sheet1, then plug in the value in column C in sheet 2. Please help me out here. Thanks.

May 15th, 2002, 06:44 AM	#2
Dexter Board Regular Join Date: Apr 2002 Location: St. Louis Posts: 71	Unless I'm missing something, this sounds like your problem would be best addressed using lookup formulas in sheet 2 without the need to create a macro.