If Lookup?

[thepartydj]

I have one file with two sheets. One sheet one in row one I have one column as name, column two as a number and column three as a month of the year. On my sheet two I have the same three columns. How can I pull just a single month (like Jan) from the sheet one to sheet two? Doing this using a formula. I would like it to be auto. Thanks!

 

[most]

I would solve it with VBA, but you could try 'Array formula'.

 

[Fluff]

What are the values in col C? Are they dates formatted to show the month, or are they text values?
If text values is it just the 1st three letters of the month?