VLOOKUP without using a table name

[gio123bg]

Hi All,
I need to check two ranges of numbers in this way

...A.................C.....................................................G
6766784.......6757138....to obtain by using VLOOLUP...#N/A
6766385.......6701385............................................#N/A
6766664.......6708222............................................#N/A
6766453.......6770623............................................#N/A
6766501..............................................................#N/A
6621344..............................................................#N/A
6757138..............................................................6757138
6757176..............................................................#N/A
6769771..............................................................#N/A
6327236..............................................................#N/A
6701385..............................................................6701385
6701352..............................................................#N/A
6589956..............................................................#N/A
6744932..............................................................#N/A
6744255..............................................................#N/A
5989271..............................................................#N/A
6708222..............................................................6708222
6700533..............................................................#N/A
6042594..............................................................#N/A
6698856..............................................................#N/A
6701149..............................................................#N/A
6770623..............................................................6770623
6770391..............................................................#N/A
6770368..............................................................#N/A
6770276..............................................................#N/A

I don't want to use a "range" in VLOOKUP but handle =VLOOKUP(A1;C1:C4;1;FALSE) this is the first cell but if I drag down this cell, the range (C1:C4) changes. I need to keep this range.

Any suggestion will be well appreciated.

Thanks in advance for your kind help.

Regards,

Giovanni

 

[VoG]

Try

=VLOOKUP(A1;C$1:C$4;1;FALSE)

 

[gio123bg]

Hi VoG! Thanks a lot!

Problem solved!

Regards,

Giovanni























видеорегистратор на авто