How to use VLOOKUP (via Formula How-Tool)

@MrShorty:
thank you!

1) I had that initially but removed it since i couldn't sync it similarly to the coding i am using for formulas. unless i want that worksheet as a read-only without animations (which people can probably google easily), i don't know if i want that

2) yes, the worksheet was only for exact match. i felt the example wouldn't represent well for approximate match. like the eg you mentioned, the search in "ranges" would be something i think people can relate better. so i wanted to do it separately. maybe i should highlight that this VLOOKUP is only for exact match.
=)

having a little bottleneck with the suggestion by 6StringJazzer on putting OK in the textbox instead of MsgBox. would need the macro to stop when the OK button appears like the MsgBox does and then resume when user clicks OK. will update once i get past that!