Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
Do you mean items that match *on the same row* or do you mean items that
match *anywhere* within the range? -- Biff Microsoft Excel MVP "Soth" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
Hi,
I meant item matches 'anywhere' within the range. Thanks "T. Valko" wrote: Do you mean items that match *on the same row* or do you mean items that match *anywhere* within the range? -- Biff Microsoft Excel MVP "Soth" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
Try this:
=IF(COUNTIF(A$1:A$20,B1),1,2) Copy to the end of data in column B. Adjust ranges to suit. -- Biff Microsoft Excel MVP "Soth" wrote in message ... Hi, I meant item matches 'anywhere' within the range. Thanks "T. Valko" wrote: Do you mean items that match *on the same row* or do you mean items that match *anywhere* within the range? -- Biff Microsoft Excel MVP "Soth" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
Thank you very much. You've solved it.
"T. Valko" wrote: Try this: =IF(COUNTIF(A$1:A$20,B1),1,2) Copy to the end of data in column B. Adjust ranges to suit. -- Biff Microsoft Excel MVP "Soth" wrote in message ... Hi, I meant item matches 'anywhere' within the range. Thanks "T. Valko" wrote: Do you mean items that match *on the same row* or do you mean items that match *anywhere* within the range? -- Biff Microsoft Excel MVP "Soth" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
Hi Soth,
If your list starts in A1, adjust $b$1:$b:$3 to accommodate the entire list and past the formula below down column c? =IF(ISERROR(MATCH(A1,$B$1:$B$3,FALSE)),2,MATCH(A1, $B$1:$B$3,FALSE)) Does this work for you? Dan |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup formula help please
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Soth" wrote in message ... Thank you very much. You've solved it. "T. Valko" wrote: Try this: =IF(COUNTIF(A$1:A$20,B1),1,2) Copy to the end of data in column B. Adjust ranges to suit. -- Biff Microsoft Excel MVP "Soth" wrote in message ... Hi, I meant item matches 'anywhere' within the range. Thanks "T. Valko" wrote: Do you mean items that match *on the same row* or do you mean items that match *anywhere* within the range? -- Biff Microsoft Excel MVP "Soth" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |