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: 1,670
Default Lookup Formula

I would like to write a formula that will do the following:

A B C D
1 Jan Feb Mar Apr
2 x x x
3 x x x x
4 x x
5 x

Looking for a formula to return the month of the first appearance of "x."
So "Feb" for row 2 "Jan" for row 3 "Mar" for row 4 and so on.

Any help is greatly appreciated.

Thanks
 
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 formula Joe Gieder Excel Worksheet Functions 0 May 14th 08 03:30 PM
Help with a Lookup formula ? Charlie7805 Excel Worksheet Functions 5 March 2nd 08 04:47 AM
Lookup formula? kwrohde Excel Discussion (Misc queries) 7 June 8th 06 10:38 PM
Max Lookup formula sam Excel Worksheet Functions 5 September 16th 05 06:55 AM
Lookup Formula - but have a formula if it can't find/match a value Stephen Excel Worksheet Functions 11 June 14th 05 05:32 AM


All times are GMT +1. The time now is 01:16 PM.

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

About Us

"It's about Microsoft Excel"