Thread: Formula to place name next to appropriate date

Spreadsheet 1: So in column "A" I have all of the dates written out. Then i need column "B" to put the appropriate name next to the date that person chose in spreadsheet 1.

Spreadsheet 2: I have a live form that feeds data into a different spreadsheet.

I am using google spreadsheets.... The formulas are the same as in excel

yep look here
http://docs.google.com/support/bin/t...en&topic=15115

no idea i do excel not google docs! in case you didnt notice the clue is in the url

try a vlookup then!
but

Spreadsheet 1: So in column "A" I have all of the dates written out. Then i need column "B" to put the appropriate name next to the date that person chose in spreadsheet 1.

where is name/date listed
normally i'd ask you attach an example. but thats going to be a tad difficult since you aren't using excel

With your dates in col A starting A1
and your imported dates in col D and names in col E
in B1=VLOOKUP(A1,D:E,2,FALSE)

dont know iF google docs has IFERROR
if it has use
=IFERROR(VLOOKUP(A1,D:E,2,FALSE),"OPEN")
If it hasn't then
=if(ISNA(VLOOKUP(A1,D:E,2,FALSE)),"OPEN",VLOOKUP(A1,D:E,2,FALSE))

IF it has conditional format same as excel
conditional format as
formula is =VLOOKUP(A1,D:E,2,FALSE)) choose a color
c/f doesnt worry about n/a
only the fact if its true or false so this will work whenever its true
or a shorter version
formula is
=MATCH(A1,D:D,0)>0