Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need function/formula help!!
I hope someone can help me.
I have a workbook with 3 sheets. sheet1=Data Entry, sheet2=daily hours, sheet3=8day totals. In sheet1- col a is name, col b is date, col c combines a&b, col d totals e&f, col e & f are #'s. each row is a different record. These are not entered in any sort of order. In Sheet2, col a =dates, row1 col b, c, d, etc are names. For example: i want cell b2 to get the data from sheet1. i need it to look up the values from sheet 2-b1 (from sheet1 col a)and sheet2-b2 (rom sheet1 col b), if it finds a match then enter the resulting number from sheet1-col d, if no match enter 0. i have a vlookup function in there now, but if it does not find a match it results in error #n/a, and i need it to enter 0 if no match found. I hope this isnt too confusing. Thank you for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need function/formula help!!
Glad to hear that. You're welcome.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "reneelimon" wrote: THANK YOU BOTH SOOOO MUCH--- IT WORKED!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need function/formula help!!
Enclose your VLOOKUP(...) formula within an "error trap" for #N/A error:
instead of =VLOOKUP(...) use =IF(ISNA(VLOOKUP(...),"",VLOOKUP(...))) That will return a zero-length string when no match is found, and will return the result when the match is found. "reneelimon" wrote: I hope someone can help me. I have a workbook with 3 sheets. sheet1=Data Entry, sheet2=daily hours, sheet3=8day totals. In sheet1- col a is name, col b is date, col c combines a&b, col d totals e&f, col e & f are #'s. each row is a different record. These are not entered in any sort of order. In Sheet2, col a =dates, row1 col b, c, d, etc are names. For example: i want cell b2 to get the data from sheet1. i need it to look up the values from sheet 2-b1 (from sheet1 col a)and sheet2-b2 (rom sheet1 col b), if it finds a match then enter the resulting number from sheet1-col d, if no match enter 0. i have a vlookup function in there now, but if it does not find a match it results in error #n/a, and i need it to enter 0 if no match found. I hope this isnt too confusing. Thank you for your help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need function/formula help!!
THANK YOU BOTH SOOOO MUCH--- IT WORKED!!!!
"Max" wrote: i have a vlookup function in there now, but if it does not find a match it results in error #n/a, and i need it to enter 0 if no match found. Try it with an IF(ISNA(..) error trap, like this: =if(isna(vlookup(...)),0,vlookup(...)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "reneelimon" wrote: I hope someone can help me. I have a workbook with 3 sheets. sheet1=Data Entry, sheet2=daily hours, sheet3=8day totals. In sheet1- col a is name, col b is date, col c combines a&b, col d totals e&f, col e & f are #'s. each row is a different record. These are not entered in any sort of order. In Sheet2, col a =dates, row1 col b, c, d, etc are names. For example: i want cell b2 to get the data from sheet1. i need it to look up the values from sheet 2-b1 (from sheet1 col a)and sheet2-b2 (rom sheet1 col b), if it finds a match then enter the resulting number from sheet1-col d, if no match enter 0. i have a vlookup function in there now, but if it does not find a match it results in error #n/a, and i need it to enter 0 if no match found. I hope this isnt too confusing. Thank you for your help |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need function/formula help!!
i have a vlookup function in there now, but if it does not find a match it
results in error #n/a, and i need it to enter 0 if no match found. Try it with an IF(ISNA(..) error trap, like this: =if(isna(vlookup(...)),0,vlookup(...)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "reneelimon" wrote: I hope someone can help me. I have a workbook with 3 sheets. sheet1=Data Entry, sheet2=daily hours, sheet3=8day totals. In sheet1- col a is name, col b is date, col c combines a&b, col d totals e&f, col e & f are #'s. each row is a different record. These are not entered in any sort of order. In Sheet2, col a =dates, row1 col b, c, d, etc are names. For example: i want cell b2 to get the data from sheet1. i need it to look up the values from sheet 2-b1 (from sheet1 col a)and sheet2-b2 (rom sheet1 col b), if it finds a match then enter the resulting number from sheet1-col d, if no match enter 0. i have a vlookup function in there now, but if it does not find a match it results in error #n/a, and i need it to enter 0 if no match found. I hope this isnt too confusing. Thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula or function? | Excel Discussion (Misc queries) | |||
A formula/function to return a formula/function | Excel Worksheet Functions | |||
Function or Formula | Excel Worksheet Functions | |||
Function-formula help | Excel Worksheet Functions | |||
Add to my Function / formula | Excel Worksheet Functions |