Similar Values search

Tests.JPG

That didn't work.
So here's a screen cap of what I'm trying to do. lets take row 3 for example.
Right now it's trying to search for a number similar to "3" in column E on the next page and then report back the value in column F.

tests 2.JPG

The issue is that now I'm over 20 tests and it is adding values and it's adding additional test values because of the number "13" being similar.
My code above worked well last year because I implemented it after 150 requests so it was searching for values similar to 150.

Try this ...

=IF($I19<>"",SUMPRODUCT(--ISNUMBER(SEARCH($A19,NewSchedule!$E$6:$E$737)),NewSchedule!$F$6:$F$737),"")

If it does not work ......


Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.