VLOOKUP and SUMPRODUCT Errors

[knuckledownlacrosse]

I am looking to do a VLOOKUP and REPLACE within a document and also have a TALLY done.

1. I would like to search the Activity code from sheet 1 against sheet 2 and spit back the actual name.

2. The other formula I was working with was trying to give me a tally of the total enrollment: =SUMPRODUCT((LEN(F:F)-LEN(SUBSTITUTE(F:F,F3,"")))/LEN(F3))

Take a look:
Screen Shot 2015-12-01 at 2.43.25 PM.png

and sheet 2:
Screen Shot 2015-12-01 at 2.43.40 PM.png


Thanks!

[Tony Valko]

Many members are unable to see images in the *.png format.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

[shg]

Also, please take a few minutes to re-read the forum rules, and then amend your thread title accordingly.

Thanks.

[knuckledownlacrosse]

I attached a file to work with.

Thanks.

[knuckledownlacrosse]

Fixed it.

Thanks for the heads up on that slip.

[Tony Valko]

Try this...

Entered on the Registration sheet in cell G2:

=IFERROR(INDEX('Tuesday Activities'!A$1:A$32,MATCH(F2,'Tuesday Activities'!C$1:C$32,0)),"")

Copy down as needed.

Not sure what you're wanting to count. Here's my best guess...

Entered on the Registration sheet in cell H2:

=IF(G2="","",COUNTIF('Tuesday Activities'!C$1:C$32,F2))

Copy down as needed.

[knuckledownlacrosse]

The first one worked! I was able to work on the second equation and got that one to work too: =SUMPRODUCT((LEN(G:G)-LEN(SUBSTITUTE(G:G,G2,"")))/LEN(G2))

[Tony Valko]

Good deal. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.