Aladin Akyurek said:
Aaron said:
I have the following formula, that is suppose to return 711, and right now it only returns 7. Will someone offer a suggestion? Thanks
{=VLOOKUP($B$5,Table,{2,3,4},FALSE)}
Care to post the expected result?
Thanks Aladin, the expected result should be 711, and the formula is returning 7 only. So the solution I am using right now is =VLOOKUP($B$5,Table,2,FALSE)&VLOOKUP($B$5,Table,3,FALSE)&VLOOKUP($B$5,Table,4,FALSE)