From: Jose on 14 Apr 2010 14:27 Hi, I have 2 different reports. One has a list of contracts with a unique id and the other has a much larger list of contracts that also have a unique TEXT id that I need to return to the smaller report. The only common field between both reports is the contract value in dollars. Any help would be great appreciated!! -- I need so much help, but right now, some Excel help will suffice!!
From: Gary Brown on 14 Apr 2010 16:01 Use the VLookup( ) function BUT GOSH, what happens if you have 2 contracts for $1,000.00.???!!! -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Jose" wrote: > Hi, > > I have 2 different reports. One has a list of contracts with a unique id > and the other has a much larger list of contracts that also have a unique > TEXT id that I need to return to the smaller report. The only common field > between both reports is the contract value in dollars. Any help would be > great appreciated!! > -- > I need so much help, but right now, some Excel help will suffice!!
|
Pages: 1 Prev: Can I combine two of or more files of the same type and layout Next: Need help formatting rows |