Results 1 to 5 of 5

Lookup function

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2009
    Location
    Lynnwood USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Smile Lookup function

    Hi - I need some help figuring out what function will perform this. I'm playing with vlookup but not quite working right.

    On "worksheet B" I have a table that is 3 col wide and 15 rows deep.
    Col 1 has values 0,1,2,3 or 4
    Col's 2 and 3 have text values in them



    on "worksheet A" I need to pull the following:

    look in table on worksheet B, and basically copy the section of the table that has the rows where col 1 has value "0", and display that section of the table in my worksheet A. So if rows 1-5 have value "0" in column 1, then I want to display the values in that row across col's 1,2 and 3. (and not display the section of the table that has value "1" in Column 1 for example. hope that made sense.

    Can anyone advise?
    Attached Files Attached Files
    Last edited by happycats; 10-28-2009 at 04:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1