VBA EXCEL IFSTRING HELP
 

Hey guys, I need someone's help if possible. I have an assignment, and
basically its a MACRO to accept as many ROWS(topics) and
COLUMNS(subject) as possible, with an OVERALL at the end. And
basically, lets just say a 4 by 2, the user selects the "RATING" and
I've inserted a row with vlookup to find the value needed, inserted a
row, then deleted the row in the beginning. However, the trouble i'm
having is with the OVERALL row.

LET ME SHOW YOU BEFORE I GET TO IN DETAIL

Y X OVERALL

A 4 2
B 2 1
C 4 1
D 2 2
OVERALL
=(INSERTED ROW Z)



RATING SCORE AVERAGE

EXCELLENT 4 (C55) 3.5
GOOD 3 (c66) 2.5
FAIR 2 1.5
POOR 1 0.5


Now basically, my program will take any value in c55, and average it
with c66. set that value to a row(AVERAGE ROW), then offset and
calculate until it gets into a blank row.

So basically what I need is for the overall row. It will take the
value in the (INSERTED ROW) and compare it to the AVERAGE ROW.
Basically, create an IF statement with the MACRO to say something like
=if(activecell=(AVERAGEROW1), (AVERAGEROW).offset(-2,0) [FOR THE
RATING]. So basically search for the value when it is = the average
row, and get the RATING in the OVERALL row.


My professor told me to research IFSTRING, however I have no clue how
do perform this function or where to find it. If you guys could help
that would be great. Let me know.