AboutPricing

Get instant live expert help on vlookup n/a error

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    keep getting na error for this =VLOOKUP(S6,Y4:Y300,3,FALSE)
    Solved by A. H. in 27 mins
    =VLOOKUP(V10,'LOOMS & WEAVER'!$M$2:$Q$57,4,0). I'm using vlookup formula and I'm getting a #NA! error. I checked every different scenario 1)checked length of text, 2)checked the reference cell, 3)checked index no. I have no idea why I'm getting the #NA! error.
    Solved by S. F. in 22 mins
    I am currently having issues with the lookup vlookup. I get an NA error. I am nesting the If, Vlookup, and Hlookup formulas.
    Solved by O. D. in 22 mins
    =IF([@[Customer Age]]<25,"Youth","NA"),IF([@[Customer Age]]25-34,"Young Adults","NA"),IF([@[Customer Age]]35-64,"Adults","NA"),IF([@[Customer Age]]>64,"Seniors","NA") i am trying to use this formula but i keep getting an error and cant get around it
    Solved by G. B. in 28 mins
    I am continually running into errors #NA and #NAME? when trying to calculate VLOOKUP. How do i get a data cell range from one worksheet to the next without running into error?
    Solved by T. Y. in 28 mins