|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 18th, 2006, 05:30 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Linking cells (VLOOUP/IF function maybe?)
Hi
I am trying to find a way to pull certain data off a particular sheet onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or a IF function. Would be good if someone could give me some help on this. Essentially I want to pull the data in columns A, B and I into a new worksheet. But I only want to pull these cells when in column H it says 2. So i guess Im saying in the new worksheet, pull data in columns A,B and I, only if in column H it says 2. If anyone could give me a hand, I would be most grateful. Many thanks for your time, Greg. 
|
|
#2
August 19th, 2006, 01:26 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Linking cells (VLOOUP/IF function maybe?)
Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html VLOOKUP There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "GregA" wrote: I am trying to find a way to pull certain data off a particular sheet onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or a IF function. Would be good if someone could give me some help on this. Essentially I want to pull the data in columns A, B and I into a new worksheet. But I only want to pull these cells when in column H it says 2. So i guess Im saying in the new worksheet, pull data in columns A,B and I, only if in column H it says 2. If anyone could give me a hand, I would be most grateful. Many thanks for your time, Greg.
|
|
#3
August 20th, 2006, 01:15 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Linking cells (VLOOUP/IF function maybe?)
.. Debra Dalgleish's nice coverage on ... INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html INDEX/MATCH -- Max Singapore http://savefile.com/projects/236895 xdemechanik ---
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
