Iferror and vblookup with two differnent names

[dalypen]

All the Data are in the same worksheet. Column A of Sheet1 Has all the College Names and data that come from a web Query and is populated automatic. I have 5 rows of data B-H that is calculated in column I From the Web Query.
Now Column P of Sheet1 has College Name that comes from Sheet7 that are mismatch so what i have is column P would show Iowa State but Column A would have Iowa St. The Formula is in Column Q is where i match =IFERROR(INDEX(Sheet1!I:I,MATCH(P:P,Sheet1!A:A,0))," ") so some colleges has no data because of the different name type. I tried a few formula but neither work.
example Idaho State comes from Sheet7 and the data in Column Q comes from Idaho St. Sheet1. Any easy formula for this?? Thanks

 

[Gerald Higgins]

Hi, this type of request is pretty common on Mr Excel, and comes about because things like name and address data are often handled differently in different places.

In my opinion the only sure way to deal with this is to clean up the data itself so that it is all consistent.

 

[dalypen]

I Got it, I Just coded a Macro and it is all good Now.