Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have read the other posts similar to my question - but I still do not
understand. Please help. My problem is I would like to lookup a code that is specific to a value to determine if it exists in a table of data I have created. For example the following table is named "DATA". VALUE CODE 1111 505 1111 506 1111 507 1112 505 1112 609 1112 803 I have a value in cell F3 and a code in cell I3. I want to be able to create a formula in cell M3 which will determine if I have a valid code for the value. For instance I need to determine if code 505 is valid for Value 1111. Since it is I need a response of "Valid". On the other hand if I have a code of 803 for value 1111 I need a response of "Invalid". Thanks for your help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Question with multiple dynamic variables | Excel Worksheet Functions | |||
Lookup function using 2 variables | Excel Worksheet Functions | |||
Lookup with Variables | Excel Worksheet Functions | |||
lookup 2 variables | Excel Discussion (Misc queries) | |||
can't figure out LOOKUP with 2 variables | Excel Discussion (Misc queries) |