LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Michael Saffer
 
Posts: n/a
Default Range Lookup? Is there such a thing like this?

Greetings!

My latest problem goes like this: :)

In Columns A,B, &C, I have a product ID, a date, and amount ordered. A1 B1
and C1 look like this:

15016 1/14/2005 70


I am trying to see if those three cells appear anywhere in a lookup table in
columns D, E, &F. The range, lets say is (D1:F5) and looks like this:

15016 1/10/2005 70
15022 1/15/2005 70
15016 1/14/2005 35
15035 1/14/2005 90
15016 1/14/2005 50

I was hoping to create a formula in an adjacent cell that would indicate yes
or no.

The answer to the above scenario would be "no" or "false" because nowhere
did anyone order 70 units of Product #15016 on 1/14/2005

Thank you SO much.

Michael Saffer


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Define a range based on another named range Basil Excel Worksheet Functions 2 February 21st 05 01:47 PM
Lookup function w/Text and Year Josh O. Excel Worksheet Functions 1 February 12th 05 11:27 PM
Lookup the latest date in a range so it appears as my result FBB Excel Discussion (Misc queries) 1 December 4th 04 03:50 AM
Lookup with search range start based on position of last blank lin rcmodelr Excel Worksheet Functions 0 November 14th 04 06:32 AM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"