Hi i have a spreadsheet with multiple workbooks.
on one workbook data is entered using lists. (the data for the Lists is on a
workbook called "lists")
when data is selected from the list i need the row above to display a value
based on the list choice.
eg if i select "chc" from the list, then the cell above displays
"06:00:14:30" if "CW" was selected from the drop down list then the cell
above displays "06:00 to 14:00"
this data is on a workbook called "Times"

CHC 06:00 to 14:30 8
CW 06:00 to 14:00 6

the formula i am using is

=IF(ISERROR(MATCH(C8,Times!$A$2:$A$21,0)),"",LOOKU P(C8,Times!$B$2:$B$21))

this seems to select the first time range only and does not seem to
reference all the data, or update if you change the list choice.

i have tried changing the sort of the "lookup" range but that does not seem
to help

hope someone can help.

Try the below instead

=IF(ISERROR(MATCH(C8,Times!$A$2:$A$21,0)),"",
VLOOKUP(C8,Times!$A$2:$B$21,2,0))

If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

Hi i have a spreadsheet with multiple workbooks.
on one workbook data is entered using lists. (the data for the Lists is on a
workbook called "lists")
when data is selected from the list i need the row above to display a value
based on the list choice.
eg if i select "chc" from the list, then the cell above displays
"06:00:14:30" if "CW" was selected from the drop down list then the cell
above displays "06:00 to 14:00"
this data is on a workbook called "Times"

CHC 06:00 to 14:30 8
CW 06:00 to 14:00 6

the formula i am using is

=IF(ISERROR(MATCH(C8,Times!$A$2:$A$21,0)),"",LOOKU P(C8,Times!$B$2:$B$21))

this seems to select the first time range only and does not seem to
reference all the data, or update if you change the list choice.

i have tried changing the sort of the "lookup" range but that does not seem
to help

hope someone can help.

Hi Jacob worked a treat. Thanks

"Jacob Skaria" wrote:

Try the below instead

=IF(ISERROR(MATCH(C8,Times!$A$2:$A$21,0)),"",
VLOOKUP(C8,Times!$A$2:$B$21,2,0))

If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

Hi i have a spreadsheet with multiple workbooks.
on one workbook data is entered using lists. (the data for the Lists is on a
workbook called "lists")
when data is selected from the list i need the row above to display a value
based on the list choice.
eg if i select "chc" from the list, then the cell above displays
"06:00:14:30" if "CW" was selected from the drop down list then the cell
above displays "06:00 to 14:00"
this data is on a workbook called "Times"

CHC 06:00 to 14:30 8
CW 06:00 to 14:00 6

the formula i am using is

=IF(ISERROR(MATCH(C8,Times!$A$2:$A$21,0)),"",LOOKU P(C8,Times!$B$2:$B$21))

this seems to select the first time range only and does not seem to
reference all the data, or update if you change the list choice.

i have tried changing the sort of the "lookup" range but that does not seem
to help

hope someone can help.