Lookup on worksheet return whole row

H

hotherps

I'm not sure what to use, I want to have a dropdown box in let's say C
on Sheet1. It's data source is a column on a worksheet called shift
C4:C5. When the user selects the dropdwonbox selection, I want the dat
in cthe column next to the source worksheet to be returned. I actuall
want two columns returned.

THank
 
H

hotherps

Thanks Frank, but I still can't get it to work.

Let me explain it again

I have 3 cells on sheet "Montest"B10 H10 I10

I have 3 cells on sheet "Shifts" A2 D2 E2

I want to enter in a value in "Montest" I10
have it find a match in "Shifts A2:A109

and return "Shifts"D2:D109 to "Montest"B10:B109
and "Shifts"E2:E109 to H2:H109

Frustrating!

Thanks agai
 
F

Frank Kabel

Hi
try the following formulas
Montest B10:
=VLOOKUP(I10,'Shifts'!$A$2:$E$109,3,0)

Montest H10
=VLOOKUP(I10,'Shifts'!$A$2:$E$109,4,0)

copy both formulas down
 
Top