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

D

DW

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
 
G

Guest

=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))
 
G

Guest

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

DW

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria to return maximum value where x = x 3
What formula do I use? 2
returning a value in a table referencing ranges 2
vlookup / index / match? 5
producing a report via a keyword - filtering and macros not suitab 1
Trying to sum cells across different worksheets in different locat 4
Sorting a list 3
Pick of random ID's 3

Top