V-Lookup Values

[skvf1]

Hi

When I am using V-Lookup, it is fetching information but not all the information is fetched although when I manually checked, values were present in the source table. V-lookup is showing N/A for those values. Below is the snip. The cells in blue have email addresses in the source table but are not fetched by V-Lookup.

Can anybody please advise what could be the reason behind this and how to fetch values against those cells where V-Lookup is showing N/A?

Thanks heaps.

 

[Ottsel]

Would you mind posting what Vlookup you have currently?

 

[skvf1]

Would you mind posting what Vlookup you have currently?

Brother, couldn't understand your question. Can you please elaborate.

What I understood, i am using this: VLOOKUP(lookup_value, table_array, col_index_number,[range_lookup])

Thanks

 

[Ottsel]

Apologies -

I wasn't asking what the layout was, but rather what YOUR Vlookup was referencing.
Example: =VLOOKUP(Sheet2!B3:I23,4,FALSE)

 

[skvf1]

Apologies -

I wasn't asking what the layout was, but rather what YOUR Vlookup was referencing.
Example: =VLOOKUP(Sheet2!B3:I23,4,FALSE)

Oh, got it.

I am using this:

=VLOOKUP(D15,'NZ Email'!C5:D7389,2,TRUE)

and with FALSE as well but same result

 

[Ottsel]

change C5:D7389 to $C$5:$D$7389

This will make it, so when you copy it downward your table array is an absolute and not relative. It won't change it to: C5:D7389, C6:D7390, C7:D7391, etc..., but D15 will become D16, D17 and so on, since it's relative.

Do this to your first or top formula, then copy it onto all the others. Let me know if that works.

 

[skvf1]

change C5:D7389 to $C$5:$D$7389

This will make it, so when you copy it downward your table array is an absolute and not relative. It won't change it to: C5:D7389, C6:D7390, C7:D7391, etc..., but D15 will become D16, D17 and so on, since it's relative.

Do this to your first or top formula, then copy it onto all the others. Let me know if that works

change C5:D7389 to $C$5:$D$7389

This will make it, so when you copy it downward your table array is an absolute and not relative. It won't change it to: C5:D7389, C6:D7390, C7:D7391, etc..., but D15 will become D16, D17 and so on, since it's relative.

Do this to your first or top formula, then copy it onto all the others. Let me know if that works.

Much thanks @Ottsel
Let me try this out. Will come back to you if not solved.

Thanks in advance mate.

 

[Ottsel]

Glad I was able to help!

 

[skvf1]

Glad I was able to help!

Thanks heaps mate. I was able to solve the problem.