updation of columns cells

[simmy.benny]

hi,

I HAVE TWO SHEET. In Grand Alliance sheet what i need is when we update the vessel name from list ,the CODE column must be updated with the particular code automatically. T he CODE column need not be a list. i am attaching what i have done. Please help me.

[KaFi]

Hi there - try this:

=IF(A22="","",VLOOKUP(A22,Data!$A$2:$E$55,3,FALSE))

Is this what you're after?

Cheers
Kafi