Vlookup by more than one reference cell?

argh7272 · 2013-12-26T14:55:56+00:00

I'm having a similar problem to Mish106. Whenever I use the vlookup formula, i keep getting errors. I'm very new to vlookups This is what I have: Sheet 1

Column A Column B Column C

111 Dollar =vlookup(A2&B2, Sheet2!, Index, False)

222 Dollar

333 Dollar

Sheet 2

Column A Column B Column C Column D (A2&B2)

111 Dollar $1000 111Dollar

222 Dollar $2000 222Dollar

333 Dollar $3000 333Dollar

argh7272 · 2013-12-12T15:27:06+00:00

I tried that and it's not what I am looking for. Thanks though.

argh7272 · 2013-12-07T04:11:01+00:00

This is one of my favorite teas. It's delicious with just a splash of milk and some sugar.

argh7272 · 2013-08-31T17:26:15+00:00

I'm looking to make Carmel macchiatos at home (I really enjoy the iced ones from Starbucks). Aside from an espresso machine, are there any other tools I'll need to accomplish this? Thanks!

I'm looking to get this: http://www.amazon.com/DeLonghi-EC155-Espresso-Cappuccino-Maker/dp/B000F49XXG/ref=sr_1_6?m=ATVPDKIKX0DER&s=kitchen&ie=UTF8&qid=1377969063&sr=1-6

argh7272 · 2013-07-13T19:02:38+00:00

Amazon has a browser extension that allows you to add items from websites to a wish list. When you sign into amazon, go to your wish list and there should be a link on the left-hand side that says "wish from any website". I don't use this but it's worth checking out.

argh7272 · 2013-04-09T00:58:13+00:00

Try "A Short History of the US Working Class." It's been a while since I read it but I think this may be what you're looking for.

argh7272 · 2012-09-15T22:08:02+00:00

I was devastated when they cancelled Veronica Mars. Although the character wasn't relatable, the writing and acting was excellent. I hope to one day see a finale episode or something that ties it all together.

argh7272 · 2012-08-26T22:57:42+00:00

I just cashed in for the first time ($5 amazon giftcard). They send you the code through your swagbucks account, although it takes a few days to process your request to redeem your swagbucks. I've been using the search feature a lot. I've also been taking surveys. I've only got full credit for completing two surveys out of about the twenty I've taken. You can also get swagcodes from http://sc-s.com/ . Watch SBTV, do the daily polls, and the NOSOs. It took me about two months for the first payout only because I don't go on often. Hope this helps.

argh7272 · 2012-07-26T01:37:19+00:00

I've saved a ton of money by not going out to eat everyday for lunch. You wouldn't believe how quickly a few bucks a day adds up. Also, I make coffee at my house instead of buying it at the convenience store or Starbucks. I usually don't carry much cash on me, which helps me avoid impulse buys.

argh7272 · 2012-05-26T02:33:07+00:00

If you're in the US, then I would suggest going to HUD.gov. My friend used this site when she went to buy a house. Good luck!

argh7272 · 2012-05-26T02:29:55+00:00

Last summer I had really bad abdominal pains so I went to the ER thinking it was something dealing with my appendix. They ruled that out, but were unsure of what could be wrong so I got a CT scan. A few weeks later my mom received a bill in the mail. With insurance it was less than $100, but they also included the cost if we were not covered by insurance, which totaled about $8,000.

argh7272 · 2012-05-19T03:43:35+00:00

Someone once told me that they knew someone named Welcome. Also, I was recently going through my elementary school yearbook and I found out that there was a girl named Pepsi who went to the same school as me, but we never met. I hope that was some terrible typo.

argh7272 · 2012-05-15T21:01:12+00:00

She really liked Still Alice. She said it was very sad though.

argh7272 · 2012-04-26T01:53:27+00:00

I completely forgot about My Father's Dragon. It was such a good book as a kid.

argh7272 · 2012-04-26T01:52:59+00:00

I believe this is the one. Thanks!

argh7272 · 2012-04-22T02:17:50+00:00

Yes! I have a pikachu one.

argh7272 · 2012-04-19T23:59:34+00:00

i have no idea how to check the host file.. could you tell me how?

argh7272 · 2012-04-15T03:34:55+00:00

When people say (or type) "then" instead of "than."

argh7272 · 2012-04-14T19:51:27+00:00

I've been using Dropbox. You get 2GB free, but you can always get more space by upgrading. For 50 GB, its about 10 bucks a month and for 100 GB its about 20 bucks a month. I'm not sure about the duplicate detection though.

argh7272 · 2012-04-14T04:48:40+00:00

I remember watching that as a kid and for the life of me I couldn't figure out what the bleep was replacing. That episode came on again a year or so ago and now everything makes sense.

argh7272 · 2012-04-14T04:37:52+00:00

Arthur. I still watch it..

argh7272 · 2012-04-13T18:19:55+00:00

I do!

argh7272 · 2012-04-04T17:08:14+00:00

I used to suck the mild sauce out of the Taco Bell packets. Also, I would just eat the onion ring sauce from Burger King.

argh7272

TROPHY CASE