Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VLookUp
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VLookUp
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. "AMaleThing" wrote: 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 couldnt find formula which only reported my criteria in a list. Can anyone suggest a formula which might do so? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VLookUp
On 23 May, 12:35, Joel wrote:
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. "AMaleThing" wrote: 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?- Hide quoted text - - Show quoted text - This worked perfectly. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |