Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup help please...
Hi, I'd like to lookup items in two different column. If item in column A, matches item in column B, then indicate #1, otherwise show #2. I'm not sure how to wright whether a match or vlookup formula. Your is appreciated. Thank you, Soth |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup help please...
What exactly do you mean by "if item in column A matches item in column B"?
Is that a line by line match or does the item in column A match any cell's item in Column B, no matter what row? If the former, then this... =IF(A1=B1,1,0) or, because of the particular output values you are looking for, this... =--(A1=B1) If the latter, then try this... =IF(COUNTIF(B:B,A1)0,1,0) or, again because of the particular output values you are looking for, this... =--(COUNTIF(B:B,A1)0) -- Rick (MVP - Excel) "Soth" wrote in message ... Hi, I'd like to lookup items in two different column. If item in column A, matches item in column B, then indicate #1, otherwise show #2. I'm not sure how to wright whether a match or vlookup formula. Your is appreciated. Thank you, Soth |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or Lookup help please...
Yes, it's a line by line match. i.e
Column A Column B Colum C John John = return value of 1 if match, else 2 Smith Bob Mary Jennifer Thank you "Rick Rothstein" wrote: What exactly do you mean by "if item in column A matches item in column B"? Is that a line by line match or does the item in column A match any cell's item in Column B, no matter what row? If the former, then this... =IF(A1=B1,1,0) or, because of the particular output values you are looking for, this... =--(A1=B1) If the latter, then try this... =IF(COUNTIF(B:B,A1)0,1,0) or, again because of the particular output values you are looking for, this... =--(COUNTIF(B:B,A1)0) -- Rick (MVP - Excel) "Soth" wrote in message ... Hi, I'd like to lookup items in two different column. If item in column A, matches item in column B, then indicate #1, otherwise show #2. I'm not sure how to wright whether a match or vlookup formula. Your is appreciated. Thank you, Soth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup, match? | Excel Discussion (Misc queries) | |||
Lookup, Match, something like this | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup Match | Excel Worksheet Functions | |||
Lookup or Match | Excel Worksheet Functions |