Hi everyone,
I have a strange problem. I consider myself an average if not decent Excel user, nested formulas, macros, basic VBA, etc, but I can't seem to get this VLOOKUP to do what I want. What has happened is I have converted a PDF of hospital success rates into an excel document. I have played with the formatting using TRIM and PROPER so that the hospital names/layouts match. If you run the VLOOKUP, it returns #N/A as if there is no value on the previous sheet. However, if you copy the hospital name from sheet 2, and search for it on sheet 1 (the same sheet as the VLOOKUP) it appears in the search function (which seems strange).
I am wondering perhaps if the issue is that I converted it from a PDF and the names on Sheet1 are formatted/coded strangely because of that.
Sheet1 Contains the Hospital Names and the success rates. Sheet 2 contains the list of hospitals I am trying to match via VLOOKUP as well as my failed VLOOKUP functions (which I believe are accurate). I have attached the file.
Thanks for the help!
Jake
Bookmarks