Sumif using Values, but returning text or values

J

Jose

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

Gary Brown

Use the VLookup( ) function BUT GOSH, what happens if you have 2 contracts
for $1,000.00.???!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
SUMIF using date ranges & referencing account numbers 1
Sumif comparing dates in criteria 2
Count of Unique Values in Access Field 9
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Using a Parameter Query in a Report? 2
VLOOKUP returning #N/A ?? 3

Top