Using VLookUp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AMaleThing - 23 May 2008 11:06 GMT

I wanted to produce a list/report from 4 other list on separate sheets
which contact a criteria, but not show list them if them do not meet
the criteria. E.g.:

> List 1

1, 500, Thomas, 30
0, 300, James, 10
0, 200, Tony, 24
1, 240, Peter, 30
1, 600, Anthony, 46

> MyReport (where the first column = 1)

1, 500, Thomas, 30
1, 240, Peter, 30
1, 600, Anthony, 46

I tried using VLOOKUP but couldn’t find formula which only reported my
criteria in a list.

Can anyone suggest a formula which might do so?

Reply to this Message

Joel - 23 May 2008 12:35 GMT

If you want a unique set of data go to worksheet menu and use Data - filter -
Advance Filter. You can also program unique filters in VBA.

> I wanted to produce a list/report from 4 other list on separate sheets
> which contact a criteria, but not show list them if them do not meet
[quoted text clipped - 16 lines]
>
> Can anyone suggest a formula which might do so?

Reply to this Message

AMaleThing - 23 May 2008 15:56 GMT

> If you want a unique set of data go to worksheet menu and use Data - filter -
> Advance Filter. You can also program unique filters in VBA.
[quoted text clipped - 21 lines]
>
> - Show quoted text -

This worked perfectly. Thank you!

Reply to this Message