Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Column A Column B Colum C
John John = return value of 1, if matches, else 2 Smith Bob Mary Jennifer I like to have a formula in column C, if item in column A, "John" matches item in column B "John", then show value of #1, else, #2 Thank you, Soth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup & Match formula | Excel Worksheet Functions | |||
Lookup/match formula? | Excel Discussion (Misc queries) | |||
LOOKUP, INDEX, MATCH (?) Formula | Excel Worksheet Functions | |||
Excel Lookup MATCH formula | Excel Discussion (Misc queries) | |||
lookup? Index? match? formula | Excel Discussion (Misc queries) |