akoni_ls

A5 is referencing a name in A1. 

Is there a formula I can put in A6 that will return the address in B1 based on the referenced value in A5? 

For example, if A5 equals A1, then return the value in the cell one column to the right of A1.

There is a building I am interested in investing in, but there are no signs listing the owner's name or contact information. I contacted the previous users of the property, but they do not own the building. The number that they shared was disconnected. Would city hall have the owner's info? Is there any other way to locate them?

I have a digital television that only picks up one channel. A small basic antenna was added, but does not help. Satellite service was purchased so that basic channels and then some could be watched, but I don't really watch much television. If I can get it to work without the service that would be great! Anyone have any ideas on how to make it work before the trial period on the service is up?

If math was broken down into multiple levels (no limit) from a pre-school level through more advanced math like geometry and trigonometry, how would you do it. Keep in mind that in grade school, a teacher may cover various levels in one school year. For example, a teacher may teach basic addition (1+1=2) which could be level 1, then more advanced addition (21+13=34) which would be level 2, then subtraction (1-1=0) at level 3, etc, etc, etc.

I am thinking of hiring an artist for a project I'm working on. This project may later be used for business purposes. I realize that under a 1099 the artwork produced and all rights thereof would belong to the employer. Could I still obtain the rights through a written agreement? Could I later be penalized by the IRS if I do not complete a 1099?

If I need a trademark(s) and copyright for a new game, what would the attorney fees be for consultation versus more hands on work? I'm looking for average fees or even lows and highs in the field.

If you can supply the name or the card number, that'll be fine. If you know the effects, attributes, etc..., that would be great.

I am looking for distributors so that I can purchase Yugioh cards by the case load. I have checked online, but have been overwhelmed by the amount of non-useful info. I have checked ebay, but there are only a few sellers available there. Of course none of them will devulge any of their distributors :) I've also had difficulty searching on the upperdeck website.