| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with two results | Excel Discussion (Misc queries) | |||
| to sum up all value results from VLOOKUP | Excel Worksheet Functions | |||
| vlookup Variables | Excel Worksheet Functions | |||
| Please Help! vlookup & match with multiple variables | Excel Worksheet Functions | |||
| how do you add vlookup results? | Excel Worksheet Functions | |||
Threaded Mode
