| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match
Trying to do a quite simple MATCH. In B53 I've got
=MATCH(E50,'SET-UP'!A1:M34,0) E50 is a date, and there is a date exactly matching it in 'SET-UP'! A1:M34', but it's coming up #N/A. Tried =MATCH(E50:F50,'SET-UP'!A1:M34,0) where E50:F50 are the 2 merged cells where the date to be matched is and get #VALUE! Also tried =MATCH(E50,'SET-UP'!A:M,0), still get #VALUE! Is there a rule against referring to other worksheets in a MATCH? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | 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 | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
