What formula can I use for this? Am a bit confused
 

I have a list of names and times and a value (number). In another sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the name.

sheet 1

col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20

Sheet 2

col A col B
Joe if sheet 1 col C 2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John

Hope someone can help.

DW

What formula can I use for this? Am a bit confused
 

Have a look in the help index for VLOOKUP

--
Don Guillett
SalesAid Software

"DW" wrote in message
...
I have a list of names and times and a value (number). In another sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the
name.

sheet 1

col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20

Sheet 2

col A col B
Joe if sheet 1 col C 2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John

Hope someone can help.

DW

What formula can I use for this? Am a bit confused
 

=IF(VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0)--"2:00",VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0),VLOOKUP(A1 ,Sheet1!$A$1:$C$3,2,0))


"DW" wrote:

I have a list of names and times and a value (number). In another sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the name.

sheet 1

col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20

Sheet 2

col A col B
Joe if sheet 1 col C 2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John

Hope someone can help.

DW

What formula can I use for this? Am a bit confused
 

=IF(VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0)--"2:00",VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0),TEXT(VLOOK UP(A1,Sheet1!$A$1:$C$3,2,0),"h:mm"))


"Teethless mama" wrote:

=IF(VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0)--"2:00",VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0),VLOOKUP(A1 ,Sheet1!$A$1:$C$3,2,0))


"DW" wrote:

I have a list of names and times and a value (number). In another sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the name.

sheet 1

col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20

Sheet 2

col A col B
Joe if sheet 1 col C 2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John

Hope someone can help.

DW

What formula can I use for this? Am a bit confused
 

Thank you dear.....this helped quite a bit........
"Teethless mama" wrote in message
...
=IF(VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0)--"2:00",VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0),TEXT(VLOOK UP(A1,Sheet1!$A$1:$C$3,2,0),"h:mm"))


"Teethless mama" wrote:

=IF(VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0)--"2:00",VLOOKUP(A1,Sheet1!$A$1:$C$3,3,0),VLOOKUP(A1 ,Sheet1!$A$1:$C$3,2,0))


"DW" wrote:

I have a list of names and times and a value (number). In another
sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the
name.

sheet 1

col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20

Sheet 2

col A col B
Joe if sheet 1 col C 2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John

Hope someone can help.

DW

What formula can I use for this? Am a bit confused
 

Oh, Don G., that helped a lot......NOT.....

Thank you Teethless Mama......Yours was much better and showed me where I
was going wrong......

D

"Don Guillett" wrote in message
...

Have a look in the help index for VLOOKUP

--
Don Guillett
SalesAid Software

"DW" wrote in message
...
I have a list of names and times and a value (number). In another sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the
name.

sheet 1

col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20

Sheet 2

col A col B
Joe if sheet 1 col C 2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John

Hope someone can help.

DW