LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup & Match formula Danny Excel Worksheet Functions 3 October 4th 07 01:19 AM
Lookup/match formula? Fiona Excel Discussion (Misc queries) 7 August 25th 07 03:56 AM
LOOKUP, INDEX, MATCH (?) Formula PS Excel Worksheet Functions 0 June 13th 07 10:20 PM
Excel Lookup MATCH formula moglione1 Excel Discussion (Misc queries) 1 February 22nd 06 06:14 PM
lookup? Index? match? formula Richard Excel Discussion (Misc queries) 4 February 22nd 06 01:50 AM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"