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
|