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? |
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 |