Info Type
View Option
Sort by Category
Show all from recent
1. | Vivinavi Hawaii Security in Waikiki(836view/11res) |
Question | Today 16:28 |
---|---|---|---|
2. | Vivinavi Los Angeles Murmur Plus(247kview/3585res) |
Free talk | Today 14:15 |
3. | Vivinavi Los Angeles oozam (zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz)(201kview/602res) |
Free talk | Today 13:50 |
4. | Vivinavi Los Angeles Moving and Disposal of Refrigerators(1kview/60res) |
Free talk | Today 09:59 |
5. | Vivinavi Los Angeles Anything and everything related to travel to Japan...(561kview/4327res) |
Free talk | Today 07:19 |
6. | Vivinavi Hawaii Lawyers who do not come to court(215view/7res) |
Question | Yesterday 23:07 |
7. | Vivinavi Hawaii About Lawyers for Harassment Cases(278view/4res) |
Question | Yesterday 18:36 |
8. | Vivinavi Los Angeles I would like to know about English.(318view/12res) |
Other | Yesterday 12:51 |
9. | Vivinavi Los Angeles My American husband is looking for someone who can...(122view/5res) |
Question | Yesterday 12:47 |
10. | Vivinavi Los Angeles HONDA PROLOGUE 2024(103view/4res) |
Free talk | Yesterday 09:38 |
Vivinavi Los AngelesMS EXCELについて質問です
- #1
-
- そうだなぁ。。。
- 2005/07/05 20:09
自分で色々試したんですが、何しろ詳しくないものでどうもうまくいきません。
例えば、2つのセルの間で、
Aのセルに "ABC" と入力した場合、Bのセルに "30"、または "XYZ" と入力したら "40"
(つまり、"ABC"=40, "XYZ"=30 を、一つのセルに文字を記入したら、別のセルにはその文字とリンクして数字が表される)
というふうに、自動的に記入されるようになんて出来るんでしょうか?
(わかりにくくてすみません)
もし分かる方がいらっしゃいましたらおしえてください。
- #2
-
- たららん
- 2005/07/05 (Tue) 21:02
- Report
lookup使えばいいんじゃないのかな?
- #3
-
- そうだなぁ。。。
- 2005/07/05 (Tue) 22:14
- Report
早速のコメントありがとうございます。
ちょっと今みてみたんですが、今ひとつ使い方が・・・ ^^;) もちょっと頑張ってみます。
そいえば、#1の中で間違いありました。
(つまり、"ABC"=40, "XYZ"=30 ・・・
・・・って、書いちゃってますけど、逆ですね。
"ABC"=30, "XYZ"=40 です。
- #4
-
- コヨーテ
- 2005/07/06 (Wed) 11:14
- Report
A | B
-----------------
1 ABC | 30
2 XYZ | 40
とどこかに表を作っておき、例えばB5のセル内に"=LOOKUP(A5,A1:B2)"と式を入れて、A5のセルにXYZと入力すると、B5の値が40と表示されますよ。
- #5
-
数字だけだったら30、40、と記入して、両方のcellをhighlightしてdragしたら(すみません、日本語でなんといったらいいのかわかりません)そのまま50、60、70とでますけど、ABCの場合はちょっとわかりませんでした。
- #6
-
- そうだなぁ。。。
- 2005/07/07 (Thu) 00:12
- Report
みなさま ありがとうございます。
コヨーテさんの方法でそれらしきものを得ました。
ただドラッグしてしまうとセルの数が一緒に変わってきてしまいますよね。
例えば、
"=LOOKUP(A5,A1:B2)"
をドラッグすると、次の段は。
"=LOOKUP(A6,A2:B3)"
そしてその下は、
"=LOOKUP(A7,A3:B4)" と。
一番左のセルは動いても良いのですが、「A1:B2」 の部分を固定しながらドラッグすることって出来るのでしょうか?
なんだか質問ばかりですみません。
- #7
-
- コヨーテ
- 2005/07/07 (Thu) 00:47
- Report
A1:B2を、$A$1:$B$1に変えてみてはどうですか?
- #8
-
- コヨーテ
- 2005/07/07 (Thu) 00:50
- Report
あ、$A$1:$B$2の間違いです。スイマセン。。
Posting period for “ MS EXCELについて質問です ” has been closed.
Please create new topic to continue the same topic.
- Find local business with Town Guide
-
- The Postal Museum is a museum that exhib...
-
The Postal Museum is a museum that exhibits ・ and introduces collections related to postal and communication services. The museum is composed of a permanent exhibition zone that divides postal history...
+81-3-6240-4311郵政博物館
-
- Texas ・ We are a pediatric dental clinic...
-
Texas ・ We are a pediatric dental clinic located in McKinney. We proudly serve children from infants to middle and high school students ・ with special needs. We can provide regular checkups ・ cleaning...
+1 (469) 336-3269Sprout Dentistry for Kids
-
- A unique cafe that uses blueberries ・ fi...
-
Five minutes by car from the first Kanada Interchange after the Aqualine, Please feel free to relax in our unique cafe that uses blueberries ・ figs ・ vegetables, etc. grown on our own farm to make yo...
+81-438-41-1216果実農園 カインの里
-
- We offer the highest quality seafood and...
-
From Japan and around the world. Main tuna toro, red meat, hamachi and salmon. Yama Seafood's fish is also used in starred restaurants. Delicious home cooking with delicious fish !.
+1 (201) 433-3888YAMA SEAFOOD
-
- For your personal style and for the heal...
-
For your own personal style and for the health of your scalp and hair, we are committed to providing a healing space that incorporates trends and even the color and perm products we use. Our partnersh...
+1 (408) 921-4354Pono Hair Salon
-
- Our veterinarians, licensed in both Japa...
-
We are here to assist you in the health care of your beloved dogs and cats. We will discuss the best possible care for you and your family animals and take the utmost care of them. Our veterinarians...
+1 (949) 502-5531Sora Animal Hospital
-
- 🌴202020 New Food Court OPEN in Waikiki🌴8...
-
The Waikiki ・ Food Hall on the 3rd floor of the Royal Hawaiian Center is a café-style food court featuring 8 unique restaurants including food made from local Hawaiian ingredients, sweets, cafes and b...
+1 (808) 376-0435Waikiki Food Hall Co.
-
- Advanced treatment based on biology diff...
-
Our CBP treatment can also cure straight neck and scoliosis. We determine the cause of pain and numbness by x-ray diagnosis, and provide fundamental treatment by improving posture and correcting the ...
+1 (408) 738-8610Sumiko Missimer, Doctor of Chiropractic
-
- The next certification class will be hel...
-
The only CPR & First Aid Class ! In response to many requests, we now offer Pet CPR and First Aid Classes for cats and dogs ! Japanese instructors provide detailed instruction ! in Torrance and Dow...
+1 (323) 834-2771South Bay CPR & First Aid
-
- < Free initial consultation > Accounting...
-
We are committed to helping our clients achieve their "Vision" by utilizing our global network. We are committed to providing comprehensive services to meet all your needs, whether you are an individu...
UNIVIS AMERICA, LLC
-
- Handling TA-Q-BIN to Japan, air import/e...
-
日本への宅急便、航空輸出入、海上輸出入、倉庫ロジ事業、お引越しの取り扱い。お荷物、物流のことはなんでもご相談下さい!(安心の日本語対応)
+1 (817) 481-9980Yamato Transport USA / Dallas Branch
-
- ~ Glass City Toyama ~
-
As the culmination of the city's urban development efforts aimed at creating a "City of Glass Toyama," the museum will be located in the "Toyama Kirari" complex, which also houses the main building of...
+81-76-461-3100富山市ガラス美術館
-
- We offer handmade set menus and boxed lu...
-
We offer handmade set menus and boxed lunches in a homey atmosphere. Our signature dishes are croquettes and yakisoba. Please come and try our food ♪ We also offer a variety of bentos and hors d'oeuvr...
+81-70-3876-9770手づくりおべんとうクロケット
-
- We are proud of our sushi and sashimi us...
-
We offer a wide variety of dishes including sushi, eel, fugu dish, Japanese beef, course meal, various set menus, and a la carte dishes, as well as Edomae tempura with sesame oil flavor. We can prepa...
+81-439-55-1621天秀
-
- Our motto is "Cheaper ・ Faster ・ More Be...
-
Our motto is "Cheaper ・ Faster ・ More Beautiful" and we aim to be a cleaning store trusted by our customers.
+81-439-55-0066ホワイト急便ミツミネ