I am trying to use VLOOKUP to pull how many bedrooms are in a particular space. The units and bedrooms numbers are on Sheet1 while the data I need to pull is on the dashboard tab. The problem is the bedrooms are not listed as "1" or "2" but instead as "Twr 1B" or "Twr 2 U" or "G 1LKU." How do...