Getting data from adjacent columns

[Dewanaf]

I'm trying to something that seems simple enough but it is becoming frustrating. I have a list of branch numbers in one column, addresses in te next column and person responsible (could be associated with several braches) in the next column. I'm trying to have the user put in the branch number in say A1 and have B1 and C1 populate with the address and Person name. Vllokup and select case only seem to return the value that is next to it not multiple columns.

Thanks in advance if you can shed some light.

 

[VoG]

You will need VLOOKUP formulas in B1 and C1. See this tutorial http://www.contextures.com/xlFunctions02.html

 

[Andrew Poulsom]

If your lookup table is in columns D:F, in B1:

=VLOOKUP($A1,$D:E,COLUMNS($D:E),FALSE)

copied to C1.

 

[Dewanaf]

Vlookup in both cells, Dahhhh

Feeling a bit stupid but thanks, works great

Thank you again