Look up Value

[Srikanth Ravada]

Hi there,

I'm trying to get the country details from column "C" in B column next to the vendor ID (see image below) But the data is neither in organized manner in column C nor in fixed intervals to get the country details. Can any one help me to get the country details next to vendor ID in column B?



Please help me!

Thanks in advance!

SRI

 

[AliGW]

Is it always the last line of the address?

 

[Srikanth Ravada]

Is it always the last line of the address?

Yes

 

[bosco_yip]

Try,

In B2, copied down :

=IF(A2="","",INDEX(C2:C$500,MATCH(1=1,INDEX(C2:C$500="",0),0)-1))

Regards
Bosco

 

[Srikanth Ravada]

That worked. Thank you so much Bosco!