NBVC said:Why do you have {2,3,4}?
What does the table look like? Where in the table is the result supposed to come from?
Book2 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Store | Addr1 | Addr2 | joe's eats | joe's eats 456 Oak St Hoboken, NJ | ||
2 | the foo bar | 123 Main St | OurTown, IA | ||||
3 | joe's eats | 456 Oak St | Hoboken, NJ | ||||
4 | adams apple farm | 999 666th Ave | Las Vegas, NV | ||||
5 | |||||||
Sheet3 |
NBVC said:Maybe there is something better, but this will do it.
=VLOOKUP($B$5,table,1,FALSE)&VLOOKUP($B$5,table,2,FALSE)&VLOOKUP($B$5,table,3,FALSE)
you can add space strings in between if you like.
ADVERTISEMENT
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)}
just_jon said:So you want to lookup the store name and return it with the address glued to it?
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?