VLOOKUP function not working on Excel 2019 on Mac

Asked Feb 18 '20 at 11:09

Active Feb 18 '20 at 11:09

Viewed 265 times

I am just trying to merge two Excels using VLOOKUP function as it is explained on Microsoft Office documentation.

Using Microsoft Excel 2019, after typing = I can't see the function, and even I introduce the formula manually, I get an error that is not ok. I am just using:

=VLOOKUP(A2,list,5,FALSE)

Where the variable list is just the selection on the second sheet where it has to find for the data. Already checked this solution with no result. Any advice?

asked Feb 18 '20 at 11:09

GoitxoCv

Is your copy of Office an English language version, or another language? – Rory Feb 18 '20 at 11:11
What, exactly, is the error message? Do you perhaps need to use semicolons for argument separators? – Ron Rosenfeld Feb 18 '20 at 11:20
@Rory How can I check this information? Menus and everything is on Spanish. – GoitxoCv Feb 18 '20 at 11:21
@RonRosenfeld Using semicolons it does not give me problems to write the formula, but is does not work. – GoitxoCv Feb 18 '20 at 11:22
What do you mean by **does not work**? – Ron Rosenfeld Feb 18 '20 at 11:24
@RonRosenfeld The result is `#Name?` for all rows where I use this formula. – GoitxoCv Feb 18 '20 at 11:32
Try the Spanish equivalent (according to the Excel function translator): `=BUSCARV(A2;list;5;FALSO)`. If that doesn't work, you will need to research to figure out the proper language for your version of Excel. – Ron Rosenfeld Feb 18 '20 at 11:34
@RonRosenfeld Didn't know that. I do have `=BUSCARV()` function but cannot make it work. I always receive `#¿NOMBRE?`. – GoitxoCv Feb 18 '20 at 11:50
Do you have any error values in the `list` range? – Rory Feb 18 '20 at 11:54
Is the `VLOOKUP` formula the entire formula in the cell? What is the contents of the cell it should be returning? – Ron Rosenfeld Feb 18 '20 at 12:08

VLOOKUP function not working on Excel 2019 on Mac

0 Answers0