vlookup

[dulitul]

Hey,

I have a spreadsheet with duplicate values. When I perform the vlookup it returns the corresponding value only on first instance. For duplicates it returns #N/A. But I want to have all values returned + duplicates. How can I solve that?

Thanks.

 

[dulitul]

That was it. How did that change?

Thanks a lot!

 

[dulitul]

That was it. What did that change?

Thanks a lot!

 

[Jonmo1]

The $ symbol LOCKS the row reference so it doesn't incriment as the formula is filled down.
It's called an absolute reference.
The same can be true to lock Column References
$A1
the A will not change to B to C as the formula is filled right.

 

[dulitul]

Brilliant.

Thanks a lot. What did $ that change?

 

[Jonmo1]

Brilliant.

Thanks a lot.

Glad to help.

What did $ that change?

See my last post.