Using VBA marcro

function Vlookup_New will check all the values in a given range for a given State name. If the State name is found, it will display something like "Match found for CA". If there is no match, it will display "No Match". Correct the function. Use the data in worksheet Question 05 to test your function. If you try to look for CA, your function should give the answer "Match found for CA". If you try to look for OR, your function should give the answer "No Match". function Vlookup_New will check all the values in a given range for a given State name. If the State name is found, it will display something like "Match found for CA". If there is no match, it will display "No Match". Correct the function. Use the data in worksheet Question 05 to test your function. If you try to look for CA, your function should give the answer "Match found for CA". If you try to look for OR, your function should give the answer "No Match