Forum Discussion
vlookup from another sheet
when i try to use vlookup formula by using another sheet then i am getting the error #NA#
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