Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple searches?
I have a list of 120 items that I have to search for amongst 5 list of data
on 5 different worksheets. Is there a way of searching for them all in one go across the 5 worksheets? using individual lookups would take an age! and ideas anyone? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple searches?
Are the ranges for your lookup tables in the same location for each
sheet? What are the ranges for your tables? How are your sheet tabs named? In article , "jiwolf" wrote: I have a list of 120 items that I have to search for amongst 5 list of data on 5 different worksheets. Is there a way of searching for them all in one go across the 5 worksheets? using individual lookups would take an age! and ideas anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |