Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a dataset that consists of 4 full columns of data. On another
sheet I have a list of values (1000 values in column A.) I would like to search in the dataset for an exact match with each value in my list returning TRUE if there's a match and FALSE if there's no match (1 return value in column B for each original list value in column A.) Is there a way to do this without using 4 vlookups? In addition, to simplifying the formula, is there a way to do this using a formula that doesn't take as long to calculate? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multi Column Sum and conditions | Excel Worksheet Functions | |||
multi column of sumif | Excel Worksheet Functions | |||
How do I seperate data in one column into multi columns | Excel Worksheet Functions | |||
Multi column Drop-down tables. | Excel Worksheet Functions | |||
representing multi category in a column chart | Charts and Charting in Excel |