At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
With a little care and some help from a knowledgeable battery supplier..., this can be done by an end-user.
-I am based in Vancouver B.C. and I deal with a company by the name of Polar Battery..., I did a google search for battery cell supplier in Vancouver BC and Polar Battery came up!!!
Note: try the using your particular city / region
-Polar was able to provide me with information as to various battery cel qualities and their prices.
Note: If your existing battery & charger is designed to use Ni-Cad..., stay with them..., likewise Ni-Mh or Li-Ion. This is because each style battery requires its own specific charging parameters. If you change the cells but not the charger..., you could cause yourself some real issues.
If you are having problems finding a particular address, try some of
following tips. In some cases the address may be listed as being in a
different city other than the one that was chosen. When the unit asks
for the City Name, try choosing Search All Cities. If the address is
listed under a different City Name, doing this will allow the unit to
find the address. Also, when entering a street name, it is important
that you leave off any direction or label. For example, if the address
was 2536 SW Melrose Place, you would enter 2536 for the house number and
only Melrose for the street name. Using the house number and
city/state, the unit will fill in the direction (SW) and label
(Place).
If you are still unable to find the address, the
mapping may not have the address available yet. Please report this to
our Cartography department using the Error Report Form which can be
found at the following link: http://www8.garmin.com/cartography/mapSource/errorForm.jsp
The crude solution is:
=IF(Sheet3!I2="WA",IF(Sheet3!H2="Vancouver","X",IF(Sheet3!H2="Camas","X",IF(Sheet3!H2="Ridgefield","X",IF(Sheet3!H2="Washougal","X",IF(Sheet3!H2="Stevenson","X",IF(Sheet3!H2="Hockinson","X","?City?")))))),"?State?")
Where ?City? appears when the city referenced in H2 is not part of the lookup
and ?State? appears when something other than WA appears in I2.
But there is probably a better way to do this using an array of valid values like the one below:
AL
NY
TX
WA
Birmingham
Albany
Abilene
Camas
Huntsville
Buffalo
Galvaston
Hockinson
Russell
New York
Houston
Ridgefield
Stevenson
Vancouver
Washougal
In the scenario you could stuff the array in another worksheet and use the HLookup function to find the "Sheet3!I2" value in the first row of this array to determine which column to look in, then VLookup "Sheet3!H2" in the column of that array to see if the city referenced exists. Of course this is a much more complex formula, but it would be easily extendible without changing the formula every time.
For mor info, see "Lookup and Reference Functions" in the Excel Help.
×