Vlookup Help

**Rich9016** · 04-07-2005, 01:47 AM

hey guys,
i have a worksheet with names in col A and their correspoinding info in subsequent columns (col A has the names, col B has the phone numbers, etc)

what i'd like to do is create another worksheet, and when someone types in a name from worksheet 1, all of their data from the entire row of worksheet 1 will appear in worksheet 2. does that make sense?

if anyone can help i'd very much appreciate it. thanks!!

**Rich9016** · 04-07-2005, 01:49 AM

but if any info changes in worksheet 1, is there a way that worksheet 2 will be updated accordingly?

**swatsp0p** · 04-07-2005, 12:15 PM

You can use a VLOOKUP to accomplish this task. On sheet2, use Col. A for the input of the desired name and place the VLOOKUP formula in cols B and beyond.

The formula in B1 would look something like this:

=VLOOKUP($A$1,Sheet1!$A$1:$G$200,2,0) where A1:G200 is the range of your data and would pull the data from the 2nd column (phone #s). Copy this formula to the right as many columns as needed, and edit the '2' to 3 in col C, 4 in col D and so on.

NOTE: with a Lookup, the name on Sheet2 will need to be entered EXACTLY as it appears in Sheet1. e.g. Robert Smith can't be entered as Bob Smith

HTH