Sep 27 2019 08:43 AM
In the attached file you will see on Sheet "Code Letter Info." the information in column B is entered manually and I have placed formulas in columns F thru M. However the formulas are extracting information from "Parcel Info. "Sheet from various columns, not the cells I am referring to in the formula. I tried a different formula in H2 and H3 and H4 but those don't seem to work either. Can someone help?
Sep 27 2019 09:38 AM
You ID:s in Parcel Info have lot of trailing spaces, thus there is no match. Not sure from which column you'd like to pick-up the information, if, for example, from S, formula could be
=INDEX('Parcel Info.'!S1:S5,MATCH(B2,TRIM('Parcel Info.'!B1:B5),0))
See H2 in attached.
Sep 27 2019 11:53 AM
Do you know how I can delete the spaces without going into each cell individually? I tried =trim(B:B) but it did not work.
Sep 27 2019 12:26 PM
To replace the leading or trailing spaces in column B, follow these steps...
This method will remove all the spaces from Column B.
Sep 27 2019 12:52 PM
That worked! Thank you guys very much!
Sep 27 2019 01:07 PM
You're welcome @pharrison!