Vlookup Array

[Aaron]

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)}

 

[Aladin Akyurek]

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)

I think that's good enough unless you have to create thousands of such triples.

 

[Aaron]

Again, thank you all for your help, and speedy responses.