Posted to microsoft.public.excel.worksheet.functions

Natahn

external usenet poster

Posts: 1

help returning the same values from two different cells

I am trying to return a set of data from an Access database, into Excel using
MS Query. I have two different cells in the database that can contain the
same value. I need to know how to return every record that has the same value
in EITHER cell. All I have achieved so far is returning those records that
have the same value in BOTH cells. If I try to exclude values that I do not
want in one cell, it also excludes records that contain the desired value in
the second cell.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA: Matching cells across columns, and returning equal values	Babymech	Excel Discussion (Misc queries)	0	January 26th 09 04:41 PM
Returning a value in one cell from values in two other cells	Fello	Excel Worksheet Functions	2	September 15th 07 01:04 PM
Returning Values	Harlan	Excel Discussion (Misc queries)	1	December 12th 06 10:19 PM
Returning Values	Troy2006	Excel Discussion (Misc queries)	5	July 31st 06 07:44 PM
Returning a sum when looking up two different values	1stcoast	Excel Worksheet Functions	1	April 17th 06 02:45 PM

All times are GMT +1. The time now is 07:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us