vLookup

[linus1234]

How do I make my table created to be autofilled from my data paste tab? I am able to use vlookups but that would still require to manually type in the name and the use the vlookup function. Is there anyway I can build in the functions so that anytime I add a new row of information to the data paste tab, it will autopopulate in my table?

I can't figure out how I should set the function so that it will pull the name along with the corresponding info for that particular person.

data paste.pngteamstructure.png

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[avk]

You can use index match formula.
Suppose above data in sheet1, sheet2, sheet3. (from column "A" To "F" for sheet1)
In sheet1 create table range. (Criteria is Name "A" column)
In sheet2 (from column "A" To "E" for sheet2)
In sheet2 "A" column is Name (A2) start data.
In "B2" enter formula. Ensure "Array formula. [SHIFT+CTRL+ENTER]

Please Login or Register  to view this content.

Copy paste as per range.
Same above process for sheet3