Lookup function

[happycats]

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?

[JBeaucaire]

Hi HappyCats. Welcome to the forum.

Mockup a sample workbook showing the data and your desired results, point out where the results came from if not obvious in your sample data.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

[happycats]

attached sample workbook to original post...

[JBeaucaire]

Manual filter in place

On worksheet B:
1) Click on A1
2) Turn on the AutoFilter (I don't use 2007, so you'll have to find that...in 2003 it's on the DATA menu)
3) Use the drop down in column A to select the value you want to see...all the rest will hide.

You can now copy the visible table to another sheet if you still want/need it on another sheet, but you can also just use the filtered table in place.

[ReFFi]

Manual filter in place

On worksheet B:
1) Click on A1
2) Turn on the AutoFilter (I don't use 2007, so you'll have to find that...in 2003 it's on the DATA menu)
3) Use the drop down in column A to select the value you want to see...all the rest will hide.

You can now copy the visible table to another sheet if you still want/need it on another sheet, but you can also just use the filtered table in place.

Shortcut Key for AutoFilter is ALT+A then hit the "T" key to turn on the filter.