| Home |
| Search |
| Today's Posts |
|
#1
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
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
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Linking cells | Excel Worksheet Functions | |||
| Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Linear Mode
