Need Help w/My VLOOKUP

[LabraLime]

Hello Everyone,

I am having trouble with my VLOOKUP formula only returning #N/A results as if it cannot locate the referenced data in my table array when it is in fact there. I was hoping someone could take a look and help me understand why / what I am missing?

This is the formula I am using:
=VLOOKUP(D2,SparesList!F:I,2,FALSE)

 

[Joe4]

Are you sure that this formula:

=VLOOKUP(D2,SparesList!F:I,2,FALSE)

shouldn't actually be this:

=VLOOKUP(D2,SparesList!H:I,2,FALSE)

It looks like you should be matching column D on your first sheet to column H on your second.