vLookup/Match/Index

**ggovensky** · 12-23-2009, 12:44 PM

This should be very simple, however I can not seem to get this to work. Simply all I am trying to do, is type in a number and have several cells copy from another worksheet. Name,City,State,Zip,Phone. I would also like to input a first name and another vlookup/match or index pulls from another worksheet and auto fills out Name & phone number. I have notes in the workbook and would applicate if anyone can solve this for me.
thank you in advance.

To second this, I would want to send out only the 1st worksheet to a client and not loose any of the data that was auto filled in.

**mpquin** · 12-23-2009, 04:21 PM

The VLOOKUP function can be used for the store address.

I am not aware of any way to autofill without a macro. I added adropdown list and added a few names as examples. Hope it helps.

-Mike

**JBeaucaire** · 12-23-2009, 08:57 PM

This technique allows you to put whatever store numbers and Lead names into your "list" pages and Excel will create an automatic "dynamically expanding named range" for each.

I created a named range called Stores on the Store List sheet with this formula:
=OFFSET('Store List'!$A$2,0,0,COUNT('Store List'!$A:$A),1)

I created a named range called Names on the Lead List sheet with this formula:
=OFFSET('Lead List'!$A$2,0,0,COUNTA('Lead List'!$A:$A),1)

Then I applied those named ranges as Data Validation drop boxes in your columns A and G on your Labor Needs sheet.

Then simple INDEX/MATCH formulas do the rest of the work. Give it a try.

vLookup/Match/Index

LinkBack

Thread Tools

Rate This Thread

Display

vLookup/Match/Index

Re: vLookup/Match/Index

Re: vLookup/Match/Index

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions