Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
lookup using two columns
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="hef, post: 5251236"] Is there a way to determine the following: I'm looking for the date that corresponds to 153117 & 20 The table I'm looking in contains the following: A B C 1 153115 20 07-18-2004 2 153116 10 07-21-2004 3 153117 10 07-20-2004 4 153117 20 07-18-2004 The answer is C4. I know you can use Match and & to look up using two columns. But ever time I try to create a formula, it comes back the the VALUE error... Help!!!!!!!!!!!!!!!!!!!!!!!!!! Thanks [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
lookup using two columns
Top
