| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index_match_error!
hi!
i am getting #NA error for the following array entered formula! =INDEX(Sheet1!B1:B4,MATCH(A1,LEFT(Sheet1!A1:A4,3), 0)) what i am doing wrong? help pl! -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
Threaded Mode
