Lookup on worksheet return whole row
 

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

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

Lookup on worksheet return whole row
 

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/

Lookup on worksheet return whole row
 

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

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

Lookup on worksheet return whole row
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


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 again


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

Lookup on worksheet return whole row
 

Perfect!

Thanks You!

Now I will have something to refer to

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