Nov 17 2017 10:01 AM
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?
Nov 17 2017 08:01 PM
Natalia,
I don't see any problem in the photo. Please provide a sample workbook with the problem.
Feb 09 2018 09:36 AM
I'm moving this question to the Excel space for better visibility.