EXCEL-VLOOKUP

Copper Contributor

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 will se with zodiac sign they have.

"vlook_value" is the year which I write in the cell above the cell with my main formula.

"table_array" is a squer of my table.

"col_index_num" is the number 1 where were written names of zodiac sign.

"range_lookup"- false or truth- neutral- all the time I see the mistake.

I don't know why this programm show me the mistake if In my mind everything is ok. Do you any mistake?

adadfafd.png

 

2 Replies

Natalia,

 

I don't see any problem in the photo. Please provide a sample workbook with the problem.

 

I'm moving this question to the Excel space for better visibility.