I have a tracking chart with various drop down menus to select various info
(ie. attendee name, location, date, etc.) I have a seperate worksheet for
each month of the year. I then want to design a confirmation/ sign-off sheet
in which I want to pull the relevant information for each attendee to the
sign off sheet by selecting their name from a drop down menu (or something
similar). I've played with the DGet formula and can't get it to work for
me... Logically what I want to do is..

Search a range of cells (say A3:E20 on Sheet 1) for criteria say ("My name"
on Sheet 1) and then have it transfer that info (the entire row worth -
meaning date, location, name etc.) to the assigned cell range on sheet 2.

Is this possible? I am in the begining stages, and can easily re-format if
that's what it comes to! I would eventually like to add more particulars
into the tracking chart such as other parties, issues, schools etc.

HELP!!! PLEASE!!!

Sounds like a VLOOKUP

So, =VLOOKUP(A2,Sheet1!A3:E20,2,0) will return the value from sheet1 column
A that matches the value in current sheet cell A2 and return the value from
column B.

Change the ,2, to ,3, to return value from column C.

the ,0 at the end means if you don't find an exact match, give an error
message...

"micheler777" wrote:

I have a tracking chart with various drop down menus to select various info
(ie. attendee name, location, date, etc.) I have a seperate worksheet for
each month of the year. I then want to design a confirmation/ sign-off sheet
in which I want to pull the relevant information for each attendee to the
sign off sheet by selecting their name from a drop down menu (or something
similar). I've played with the DGet formula and can't get it to work for
me... Logically what I want to do is..

Search a range of cells (say A3:E20 on Sheet 1) for criteria say ("My name"
on Sheet 1) and then have it transfer that info (the entire row worth -
meaning date, location, name etc.) to the assigned cell range on sheet 2.

Is this possible? I am in the begining stages, and can easily re-format if
that's what it comes to! I would eventually like to add more particulars
into the tracking chart such as other parties, issues, schools etc.

HELP!!! PLEASE!!!