Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default using VLookup with two variables to get results

I have a worksheet that is completely formula driven. It pulls all its data
from a worksheet within the same workbook. The worksheet is operated by two
data valadation lists. I need to see if I can use a Vlookup or something to
pull a comment box from one worksheet, depending on the information from the
two data valadation boxes. I was using the below formula when there was just
one variable. Please help.

=IF(ISERROR(VLOOKUP(C5,DATA!B1:R1999,17,FALSE)),"N o
Responses",VLOOKUP(C5,DATA!B1:R1999,17,FALSE))

the other list is in C6
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default using VLookup with two variables to get results

VLOOKUP operates on one matched value.

Maybe something like
=IF(ISNUMBER(AND(MATCH(C6,DATA!B1:R1999,0),MATCH(C 5,DATA!B1:R1999,0))),"MATCH","NOT MATCHED")

??

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Scott@CW" wrote:

I have a worksheet that is completely formula driven. It pulls all its data
from a worksheet within the same workbook. The worksheet is operated by two
data valadation lists. I need to see if I can use a Vlookup or something to
pull a comment box from one worksheet, depending on the information from the
two data valadation boxes. I was using the below formula when there was just
one variable. Please help.

=IF(ISERROR(VLOOKUP(C5,DATA!B1:R1999,17,FALSE)),"N o
Responses",VLOOKUP(C5,DATA!B1:R1999,17,FALSE))

the other list is in C6

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default using VLookup with two variables to get results

C5 is storing a date list (JAN07, FEB07,MAR07)
C6 is storing a list of names

What i need is for it to match the values of c5 and c6 then go over 17
columns and give me the contents of column "R" for the match.

"Dave F" wrote:

VLOOKUP operates on one matched value.

Maybe something like
=IF(ISNUMBER(AND(MATCH(C6,DATA!B1:R1999,0),MATCH(C 5,DATA!B1:R1999,0))),"MATCH","NOT MATCHED")

??

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Scott@CW" wrote:

I have a worksheet that is completely formula driven. It pulls all its data
from a worksheet within the same workbook. The worksheet is operated by two
data valadation lists. I need to see if I can use a Vlookup or something to
pull a comment box from one worksheet, depending on the information from the
two data valadation boxes. I was using the below formula when there was just
one variable. Please help.

=IF(ISERROR(VLOOKUP(C5,DATA!B1:R1999,17,FALSE)),"N o
Responses",VLOOKUP(C5,DATA!B1:R1999,17,FALSE))

the other list is in C6

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
Vlookup with two results Luke Excel Discussion (Misc queries) 2 March 22nd 07 06:41 PM
to sum up all value results from VLOOKUP Linn Excel Worksheet Functions 1 March 7th 07 03:45 AM
vlookup Variables Megadrone Excel Worksheet Functions 2 November 29th 06 12:30 AM
Please Help! vlookup & match with multiple variables ivygirl Excel Worksheet Functions 2 January 7th 06 10:46 AM
how do you add vlookup results? Anna Excel Worksheet Functions 3 March 26th 05 04:05 AM


All times are GMT +1. The time now is 01:25 PM.

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

About Us

"It's about Microsoft Excel"