Copying into ranges


Hi everyone, sorry about the title, but I wasn't entirely sure what to
call the thread.
What I'm working with is a small list of numbers in one database (List
A), and a large list in another (List B), and I want a formula to check
through List B, and any number thats in List A, I want to copy a new
formula to the neighbouring cell.
EG.

List a
100
105
106
109

list b
100
101
102
103
104
105
106
107
108
109
110...

I want it to come out like this

100 Formula in next column
101
102
103
104
105 Formula in next column
106 Formula in next column
107
108
109 Formula in next column
110...

Thanks


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21390
View this thread: http://www.excelforum.com/showthread.php?threadid=380436

.

Relevant Pages

  • Re: Defect Trailer
    ... thats so awesome looking forward to getting it ... dude, unicycling is awesome ... Schmidty563's Profile: http://www.unicyclist.com/profile/9867 ... Prev by Date: ...
    (rec.sport.unicycling)
  • Re: whats your best trick(s)?
    ... thats pretty awesome dude. ... chosen's Profile: http://www.unicyclist.com/profile/9281 ... Prev by Date: ...
    (rec.sport.unicycling)
  • Re: strongest seat post .. HELP
    ... Thats what Id get. ... uniMcPeat ... uniMcPeat's Profile: http://www.unicyclist.com/profile/10313 ... Prev by Date: ...
    (rec.sport.unicycling)
  • Re: Copying into ranges
    ... so if there are dupes you want "some" formula in the next column. ... > formula to the neighbouring cell. ... > carlito_1985's Profile: ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Unicycles needed in Southampton, UK!
    ... Thats ok, if arrangements can be made for it to be transported to here, ... Loosemoose's Profile: http://www.unicyclist.com/profile/6326 ... Prev by Date: ...
    (rec.sport.unicycling)