Valigation List of names to return phone, email, fax

[tommyb2825]

I know this should be easy, but I can't figure it out.

I have a list of names. Depending on which name is selected I want to put phone, fax and email in the 3 cells below that.

Name:
Phone:
Fax:
Email:

I made table with Name Phone Fax Email in 4 columns, but I can't figure out how to use vlookup th look in the cell above where I want my results and get the cooresponding p/f/e.

Tom

 

[rs2k]

Hi Tommy, welcome to the board,

Here is a breakdown of VLOOKUP, in this example the criteria is in A1 and the vlookup formula is in B1.

Formula in B1, =VLOOKUP(A1,D1:G10,2,0)
It breaksdown like this;
A1 - This is the cell that holds the value you want to lookup.
D1:G10 - This is the range that has the value used in A1, so somewhere in col D (D1-D10) will have the same value as whats in A1.
2 - This is the number of columns to the right of column D, so 2 would make it Col E, 3 would make it Col F etc...
0 - This is the same as FALSE, which means it has to return an exact match, if you use TRUE, then it will return the nearest match.
It is good practice to use absolute references in your range, it makes it easier for dragging formulas around. An absolute reference is when a dollar ($) sign is placed in front of a cell reference, which means it will lock on to that row or column. So to use the example above with absolute references, it would look like;
=VLOOKUP(A1,$D$1:$G$10,2,0)
To drag the formula down use an absolute reference on the lookup criteria (A1) column, but, only before the 'A'
=VLOOKUP($A1,$D$1:$G$10,2,0)
To drag the formula across, move the absolute reference to before the '1'
=VLOOKUP(A$1,$D$1:$G$10,2,0)

HTH
Colin

 

[tommyb2825]

Thank!