Vlookup

[Justinian]

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 I write the formula so Excel finds the number 1, 2, or 3 on the Sheet1 list and pulls that number into the formula on the dashboard tab?

https://app.box.com/s/kf4ib8ki90hjc8tpuxlfxgjjaf8itjay

 

[HockeyDiablo]

=IF(ISNUMBER(SEARCH("1",G3)), "1",IF(ISNUMBER(SEARCH("2",G3)), "2",IF(ISNUMBER(SEARCH("3",G3)), "3", "No")))

 

[Justinian]

I am not sure what you want me to do with this. Where is the reference to my grid of units?

 

[Justinian]

Anyone else?