Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / August 2006

Tip: Looking for answers? Try searching our database.

Linking cells (VLOOUP/IF function maybe?)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GregA - 18 Aug 2006 17:30 GMT
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.
Max - 19 Aug 2006 13:26 GMT
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
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 12 lines]
>
> Greg.
Max - 20 Aug 2006 01:15 GMT
> .. Debra Dalgleish's nice coverage on ... INDEX/MATCH at her:

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.