| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH() Function and Blanks
I have a column of values and am trying to identify where values appear in
the column. For example, in A1 thru A5: cow mouse pig horse Note A3 is blank. If I put "pig" in B1 then the formula =MATCH(B1,A1:A5,0) correctly returns 4 If I leave B1 blank, the formula returns #N/A rather than 3. I need the result to be 3. I can make a UDF to give the correct result, but I can't use VBA in this application. So can I find values in a list even if the value is a blank?? -- Gary''s Student - gsnu2007xx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are blanks being ignored by my MIN function? | Excel Worksheet Functions | |||
| growth function with blanks | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
Threaded Mode
