Vlookup Sheet Question

[Richard Bonilla]

Hello, 

I am trying to extract data quickly and find my monthly averages. When I type the function in, however, it keeps spitting back N/A. What am I doing wrong?

[#2]

Mr. Bonilla

pls see attached file..

[#3]

Thank you but I cannot open the file. Also, what was I doing wrong??

[#4]

in your vlookup formula - it s returning #N/A because it can not find your search.
also I noticed that it is looking at columns B:K - but the comp parts is in column A.
you would want to change B:K to A:K.
also use IFERROR formula to bypass the error message.
=IFERROR(VLOOKUP(B4,Sheet3!A:K,10,FALSE),"")
hope this helps
thanks..

[#5]

hope you can open the attached file..

[#6]

any feedback?

[#7]

Works great now!

[#8]

glad it helped..