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 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?

 

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 18, 2017

    Natalia,

     

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

     

Resources