How to lookup a name if a cell has a date in it?

**country101** · 06-12-2012, 09:49 PM

I have a spreadsheet that keeps track of our qualifications. It has a master page where all the info shows up on and a supervisor page for each supervisor(currently 7) on each crew to enter the information on. We have over 30 supervisors that may perform the qualifications, so each supervisor page has a list to choose from in case that particular supervisor did not do it. Currently, I have an IF statement that says if there is a date in my data sheet(pulled off the supervisor's page), then use the cell on the supervisor's page that contains the list to find the name. If there is nothing, it is left blank. Is there a simpler way to look up the name? All the lookup formulas look for a value or something and can only pick prom the cells beside it, so even if I made a new array that made anything greater than zero to come back TRUE, it would only pick from the 7 supervisors, and not from whatever was entered in the cell with the drop down.

This may not make sense.... Basically I want to get away from my if statement to something simpler and that will be able to handle more than 7 arguements. I know there is a way to do it with VBA, but I am even dumber with that than I am some of these formulas.

**dilipandey** · 06-13-2012, 12:37 AM

Hi country101,

Welcome to the group.

Please upload a excel workbook to explain your query. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**country101** · 06-13-2012, 12:54 AM

Here you go.

**dilipandey** · 06-13-2012, 01:41 PM

Hi country101,

Suggest you to explain your query basis your attachment as your post #1 do not have any mention of column/ row/ range.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**country101** · 06-16-2012, 09:24 PM

What I am trying to do is to retrieve a name from the supervisors' sheets if there is a date entered in the appropriate cell. So, for example, if there is a date in DeltaCrew!D6 it would look on each of the following supervisors pages in cell E5 and select the name that was entered via the drop down. It could also check to see if there was a date on the data sheet, instead of DeltaCrew! Right now, the formula to find the name is

Please Login or Register  to view this content.

This is cumbersome and is at the max number of arguments. I would use a lookup type formula, but I dont know how to use those very well, and from what I understand, they want a value and are limited to 29 arguements when I have over 30 supervisors anyway.

**dilipandey** · 06-17-2012, 03:35 AM

to retrieve a name from the supervisors' sheets if there is a date entered in the appropriate cell.

Where you want the result to appear ?

Regards,
DILIPandey

<click on below 'star' if this helps>

**country101** · 06-18-2012, 08:27 PM

The result for the first set of columns would start in E6 on Delta Crew! since all the data is coming from the "Dicuss: Critical Admin Tasks" columns.

**dilipandey** · 06-19-2012, 02:35 PM

Dicuss: Critical Admin Tasks" columns.

Not able to find this column ?

Regards,
DILIPandey

<click on below 'star' if this helps>

How to lookup a name if a cell has a date in it?

LinkBack

Thread Tools

Rate This Thread

Display

How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Re: How to lookup a name if a cell has a date in it?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions