VLOOKUP + TRIM, TRIM Lookup table array...

Originally Posted by mangesh.mehendale

Attachment 485377


getting NA error

I believe It should be work, however if it is not working and you are putting Vlookup for Numbers retrieving, instead of Vlookup you can use Sumproduct function which can work after the closed book.

If you can share your files it would be easy to understand actual problem as Here it is working lyk charm

or Try to drag the formula till to the end see if any data is retrieving...

#N/A means that that perticula lookup value is not lookup vector

Hope this will help you