Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 05:27 PM
lshaw
 
Posts: n/a
Default Is it possible to do a vertical lookup that matches on 2 criteria



  #2   Report Post  
Old May 16th 05, 05:51 PM
Peo Sjoblom
 
Posts: n/a
Default

Post a proper quaetion in the body of the message, your subject line gets
truncated

Regards,

Peo Sjoblom
  #3   Report Post  
Old May 16th 05, 06:42 PM
Mexage
 
Posts: n/a
Default

I agree with Peo, but as a tip: you can drag the border dividing the posts
and the current one to see all the subject.

Regarding your question, you cannot do it with the VLookup. The thing is
that the solution depends on your needs. What would happen if more than two
values meet the criteria?

Exactly what do you want to do here?

G.Morales

"Peo Sjoblom" wrote:

Post a proper quaetion in the body of the message, your subject line gets
truncated

Regards,

Peo Sjoblom

  #4   Report Post  
Old May 16th 05, 06:52 PM
lshaw
 
Posts: n/a
Default

Thanks for the tip!
I am trying to search a table and match both on a client and date. I am
fine if it just picks up the first combination because I have already
summarized the data on that combination.

"Mexage" wrote:

I agree with Peo, but as a tip: you can drag the border dividing the posts
and the current one to see all the subject.

Regarding your question, you cannot do it with the VLookup. The thing is
that the solution depends on your needs. What would happen if more than two
values meet the criteria?

Exactly what do you want to do here?

G.Morales

"Peo Sjoblom" wrote:

Post a proper quaetion in the body of the message, your subject line gets
truncated

Regards,

Peo Sjoblom

  #5   Report Post  
Old May 16th 05, 07:00 PM
Peo Sjoblom
 
Posts: n/a
Default

This method might be of help


http://tinyurl.com/ctdqo


just replace the names in the example with cell references where you put
client and date


Regards,

Peo Sjoblom

"lshaw" wrote:

Thanks for the tip!
I am trying to search a table and match both on a client and date. I am
fine if it just picks up the first combination because I have already
summarized the data on that combination.

"Mexage" wrote:

I agree with Peo, but as a tip: you can drag the border dividing the posts
and the current one to see all the subject.

Regarding your question, you cannot do it with the VLookup. The thing is
that the solution depends on your needs. What would happen if more than two
values meet the criteria?

Exactly what do you want to do here?

G.Morales

"Peo Sjoblom" wrote:

Post a proper quaetion in the body of the message, your subject line gets
truncated

Regards,

Peo Sjoblom



Reply
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
Lookup Lookup Lookup MR Excel Worksheet Functions 2 March 10th 05 02:59 AM
Lookup Function Problem seve Excel Discussion (Misc queries) 9 February 28th 05 03:46 AM
Lookup function w/Text and Year Josh O. Excel Worksheet Functions 1 February 13th 05 12:27 AM
Vertical lookup help needed Have three columns R,S,T Excel Worksheet Functions 1 December 11th 04 12:11 PM
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:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017