the value in C1 on EST sheet is NUMBER, where as the values in column A on CMPM sheet are TEXT.
if users are going to enter values in C1 on EST sheet, you could use the following formula to convert the value in C1 from NUMBER to TEXT, in which case you will not encounter an error:
=INDEX('CMPM Data'!N:N,MATCH(TRIM(C1),'CMPM Data'!A:A,0))
Last edited by icestationzbra; 01-16-2013 at 01:25 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks