Hi
use something like
=VLOOKUP(C3,'shifts'!$C$4:$D$5,2,0)

--
Regards
Frank Kabel
Frankfurt, Germany

"hotherps " schrieb im
Newsbeitrag ...
I'm not sure what to use, I want to have a dropdown box in let's say
C3
on Sheet1. It's data source is a column on a worksheet called shifts
C4:C5. When the user selects the dropdwonbox selection, I want the
data
in cthe column next to the source worksheet to be returned. I
actually
want two columns returned.

THanks


---
Message posted from http://www.ExcelForum.com/