Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=INDEX(BUSINESS,MATCH(B2,EIN,0))
i have a list of Employer Edentification Numbers (EIN)H2:H20 and a List to
the left with the matching Business name I2:I20. i created a spread sheet with the above formula in column a. the first time i created the page it worked by taking what was in column b and looking in EIN and Business and match up the appropriate name and now when i try to do this is does not work. this is the second spread sheet i have created because after a few time the first one stoped working. Column is filled with #NA even after i copy and paste form another application. i do not know why i have so much trouble with this formula. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max using Index/Match Help | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Index Match | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |