I'm banging my head against my desk here. I know this works. I'm using it on one worksheet in the book and trying to do it on another one and I'm getting nothing but "#N/A".
Please Login or Register to view this content.
1 2 2.31551 1 1 2 1.90862 2 1 2 2.33591 3
That SHOULD return 2.31551 from column 3, but it's not. Gah. Any ideas as to why its not? If I do MATCH90, it will return that value, but it also returns that value for any variation of the formula so that won't work.
The next line below it would just be:
etc.Please Login or Register to view this content.
Bookmarks