| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| If formula - got myself confused! | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Linear Mode
