Inserting data on one sheet from another sheet
You'll probably want to wrap the functions to avoid the #NA:
B2: =IF(A2<>"", VLOOKUP(...), "")
Quote:
> Assume your cell with the validation list is A2. Then one way:
> B2: =VLOOKUP(A2, Sheet1!$A$2:$J$100, 2, 0)
> C2: =VLOOKUP(A2, Sheet1!$A$2:$J$100, 3, 0)
> ...
> > Here is what I'd like to do (but I can't seem to figure out how using
> > Validation):
> > 1. I have a table in Excel with row and column headings.
> > 2. The leftmost cell in the row has the name of that row
> > 3. On another sheet in the same workbook I'd like to pull down a
> > dropdown list that lets me pick from the list of names.
> > 4. When I pick a name, I'd like that row to fill in with the data from
> > the other worksheet.
> > Another way of saying this is that I want to pick from a list in one
> > cell and have other cells fill in with data that is located on another
> > worksheet.
> > The Validation command lets me create the list but it won't fill data
> > into multiple cells.
> > I'm using Excel XP.
> > Thanks.
