Can someone tell me why this keeps returning a #N/A error when it shouldn't.
I'm using match to find the lookup value. On its own, the
"G"&MATCH(B11,$G$5:$G$780,0)+4 portion of the formula correctly evaluates to
G29, but when used in the vlookup, it gives me #N/A.

=VLOOKUP("G"&MATCH(B11,$G$5:$G$780,0)+4,$G$5:$I$78 0,2,FALSE)