Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function for two variables and return another cell?
Hi! I am looking for some help. Seems pretty simple but I can't seem to
figure it out. I know I'll need a lookup function and an "AND" function of some sort... Take a look and let me know what you think. row/column A B C D 1 New SSN 1st signed Blue 2 2 New SSN Calc - not signed Green 1 3 Previous SSN 1st signed Red 3 So I need help finding the combination of "New SSN" and "1st signed" and I need it to return the corresponding number. So for example, this one would return the number "2". Any suggestions? Basically I need a formula that looks up "New SSN" in column A and "1st signed" in column B and then return the corresponding value in column D. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return multiple values using a lookup function | Excel Worksheet Functions | |||
Lookup based on two variables and return a third | Excel Worksheet Functions | |||
Lookup function - can it return the higher value? | Excel Discussion (Misc queries) | |||
Lookup function using 2 variables | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions |