robertgrumbles
New Member
- Joined
- Sep 27, 2011
- Messages
- 35
So I am trying to use a Vlookup on a cell that has a large amount of characters. Basically, the cell is a multiple choice question, and I need the answer returned to the cell next to it. Right now I am using match and vlookup functions to accomplish this, but when a large question is pulled, the functions don't work. I'm guessing that I am exceding some kind of character limit. Is there a workaround for this? I am thinking I should use the left function to match up the first 50 or so characters and look those up. Here is the functions I am using right now. I need them modified so that they lookup only the first 50 characters. Thank you so much in advance!!!
=OFFSET(Database!$C$2,MATCH(Front,DynamicList,0)-1,0)
=VLOOKUP(DropDown,Database!B:E,4,false)
"Front", "DynamicList", and "DropDown" are all named ranges.
Thank you again!!!
=OFFSET(Database!$C$2,MATCH(Front,DynamicList,0)-1,0)
=VLOOKUP(DropDown,Database!B:E,4,false)
"Front", "DynamicList", and "DropDown" are all named ranges.
Thank you again!!!