View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
 
Posts: 126
Default Sumif using Values, but returning text or values

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!!