Forum Discussion

Natalia P.'s avatar
Natalia P.
Copper Contributor
Nov 17, 2017

EXCEL-VLOOKUP

I have a little problem with formula: VLOOKUP. I write everything ok (I think so) but my formulas aren't fullfild. I want to write that all time when somebody write their year of the birth, they wil...
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 11, 2018

My guess

=OFFSET($A$2,MOD(($F$15+8),12),0)

is enough if the purpose is to return Zodiac name. If to train in VLOOKUP - that's another story.

 

 

Willy Lau's avatar
Willy Lau
Iron Contributor
Feb 11, 2018

Thanks Sergei.  It is the best way to return Zodiac name.  

Resources