Need help with vlookup I believe

[pdawg123]

Hi I want to create a calendar type thing that will bring in all the information I need from the Information sheet to the Summary sheet based on the date on the summary sheet. The only issue I have is when there is multiple values for the same day as I have in the example attached. There are 2 multiple June 1st dates and it brings in the information from the first occurrence. What formula should I use?

https://spreadsheets.google.com/spr...DD_Y3dDRSd01VU3JEUkhuaFFoSnZnSnMySmc&hl=en_US

 

[asad]

Try:

Excel Workbook
	A	B	C	D	E
3	Todays Date		1/06/2011
4
5			abc	123 main st	abc
6			nbc	222 main st	ghi
7			0	0	0
Summary

Asad

 

[pdawg123]

Hi thanks! Not quite coming out right.. Please see below spreadsheet but I added tomorrows date also to the mix and for todays date it returns everything and for tomorrows date it repeats the same line. Also I would like for the others to show - not 1/0/1900.

https://spreadsheets.google.com/spr...DD_Y3dGZocmZSM0lQLVpHNlRDQ09fU3MzRkE&hl=en_US

Try:

Excel Workbook
	A	B	C	D	E
3	Todays Date		1/06/2011
4
5			abc	123 main st	abc
6			nbc	222 main st	ghi
7			0	0	0
Summary

Asad

 

[asad]

Sorry about the delay, I got stuck with another job. But here it is finally.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3	Todays Date		1/06/2011					Todays Date		2/06/2011
4
5			nbc	123 main st	abc					fox	789 main st	nop
6			abc	456 main st	hij
7
Summary

Asad

 

[T. Valko]

Hi I want to create a calendar type thing that will bring in all the information I need from the Information sheet to the Summary sheet based on the date on the summary sheet. The only issue I have is when there is multiple values for the same day as I have in the example attached. There are 2 multiple June 1st dates and it brings in the information from the first occurrence. What formula should I use?

https://spreadsheets.google.com/spr...DD_Y3dDRSd01VU3JEUkhuaFFoSnZnSnMySmc&hl=en_US

See if this is what you had in mind:

VLOOKUP with multiple returns

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[pdawg123]

thanks figured it out works perfectly..

Thank you!