Aug 16 2019 11:31 AM
when i try to use vlookup formula by using another sheet then i am getting the error #NA#
Aug 16 2019 12:23 PM
Aug 17 2019 03:19 AM
It doesn't matter you VLOOKUP on the same or another sheet. Main reasons for #NA error with VLOOKUP are described here How to correct a #N/A error in the VLOOKUP function
Aug 17 2019 04:49 AM
Hi
Naming the "Table Array" makes it easier and less error prone when creating a 2 dimensional function (like the one you are talking about).
Naming is as easy as selecting the Table array and typing any name of your choice (No Spaces) in the Name Box (to the left side of the Formula Bar) followed by hitting ENTER (for the name to stick)
Good luck
Nabil Mourad