| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking for Match
Hi there, I would like to use a function that would look at a number in D1,
check to see if it exist in range A1: A8, if the number does exist then display the D1 number in the formula cell, else display the number 1. If Number exist! A B C D E 1 5 25 2 9 3 25 Formula 25 4 1 5 15 6 8 7 3 8 5 If Number does not exist! A B C D E 1 5 11 2 9 3 25 Formula 1 4 1 5 15 6 8 7 3 8 5 Thank You for any Help! Craig |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
checking for Match
=IF(ISERROR(MATCH(D1,A1:A8,0)),1,D1)
-- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Craig" wrote in message Hi there, I would like to use a function that would look at a number in D1, check to see if it exist in range A1: A8, if the number does exist then display the D1 number in the formula cell, else display the number 1. If Number exist! A B C D E 1 5 25 2 9 3 25 Formula 25 4 1 5 15 6 8 7 3 8 5 If Number does not exist! A B C D E 1 5 11 2 9 3 25 Formula 1 4 1 5 15 6 8 7 3 8 5 Thank You for any Help! Craig |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
checking for Match
Thanks.... exactly what I was looking for!
Craig "Jim Cone" wrote in message ... =IF(ISERROR(MATCH(D1,A1:A8,0)),1,D1) -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Craig" wrote in message Hi there, I would like to use a function that would look at a number in D1, check to see if it exist in range A1: A8, if the number does exist then display the D1 number in the formula cell, else display the number 1. If Number exist! A B C D E 1 5 25 2 9 3 25 Formula 25 4 1 5 15 6 8 7 3 8 5 If Number does not exist! A B C D E 1 5 11 2 9 3 25 Formula 1 4 1 5 15 6 8 7 3 8 5 Thank You for any Help! Craig |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Checking and IF ? | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
![Craig[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
