First a word of thanks to all that have given advice over the last few days. I finally got my function to work on one spread sheet now I modified it to use with different data and need to add a SUMIF,
The equation so far is this: =IF(ISERROR(VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE)),"HELP",VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE))
The lookup ($A23&D$3)=19176, this appears twice on the referenced sheet one value is 1000 the other is 500. I need to add a SUMIF in my function to find all instances of $A23&D$3 and add them together, in this case return 1500. Please ignore the term "HELP" in the equation, it is a flag for me elsewhere and will be replaced with "" when everything works properly.
Any takers? Happy Easter to all!!
This message was edited by rsw8679 on 2002-03-29 13:57
This message was edited by rsw8679 on 2002-03-29 14:18
The equation so far is this: =IF(ISERROR(VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE)),"HELP",VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE))
The lookup ($A23&D$3)=19176, this appears twice on the referenced sheet one value is 1000 the other is 500. I need to add a SUMIF in my function to find all instances of $A23&D$3 and add them together, in this case return 1500. Please ignore the term "HELP" in the equation, it is a flag for me elsewhere and will be replaced with "" when everything works properly.
Any takers? Happy Easter to all!!
This message was edited by rsw8679 on 2002-03-29 13:57
This message was edited by rsw8679 on 2002-03-29 14:18