Hi I am getting an error when using VLOOKUP due to some items having more than 250 characters. The current vlookup is;
=VLOOKUP(C106,Table3,2,0)
For the life of me i can not figure out how to convert this to an index/match formula. Any help would be highly appreciated!
=VLOOKUP(C106,Table3,2,0)
For the life of me i can not figure out how to convert this to an index/match formula. Any help would be highly appreciated!