| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help vlookup,match
I need to create a formula that takes a column of numbers and searches for
matches in another colume and then gives a value of true to another column. Can anyone help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help vlookup,match
=ISNUMBER(MATCH(A2,$B$2:$B$100,0))
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Nancy" wrote in message ... I need to create a formula that takes a column of numbers and searches for matches in another colume and then gives a value of true to another column. Can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
