List Lookup

[bw]

I have a list in Column A. In Column B, I have data that "goes along" with the same data
in Column A, row for row. This information is in Worksheet1.

Worksheet1 example:
Column A Column B
Row1Data 6:00am
Row2Data 7:00am
Row3Data 10:00am

On Worksheet2, I want to use this list to select Row1Data, Row2Data, or Row3Data
from a drop down list box, and then fill in the the next column of data from Column B that
matches the drop down row that I select from Column A.

So on Worksheet2, if I selected Row3Data from the list box, I would "calculate" a value
from Column B of worksheet 1 to be 7:00am.

Worksheet2 example:
ColumnA ColumnB
Row2Data 7:00am (from a calculation)

So how do I calculate the value of ColumnB in Worksheet2?

I hope I've made this clear...

Thanks,
Bernie

 

[Frank Kabel]

Hi
enter the following in B1
=VLOOKUP(A1,'sheet1'!$A$1:$B$20,2,0)

 

[bw]

Excelent Frank...
Works perfectly.

Thanks,
Bernie