How to take first Value by lookup formula in macro

[mohan.r1980]

Hi,

i am able to take last value of particular column but i dont know how to evaluate in lookup formula by extracting first value.

Please Login or Register  to view this content.

Please suggest

[jindon]

Isn't it just

Please Login or Register  to view this content.

?

[mohan.r1980]

hi Jindon Sir,

great!!, Nice to see you and also thanks for another method to get the last value.

how can i get first value of same columns?

[jindon]

It should get the first match...

[mohan.r1980]

ohh no

sorry sir i thought its a last value variable result i.e. iLastCenter.

actually i expected iFirstCenter .

my misunderstanding.

thank you so much for your solution, its working fine.

have a good day and good health.

[jindon]

Ahh, should have used iFirstCenter...

[mohan.r1980]

Hi Jindon Sir,

sorry for asking same level question.

while evaluate in 2 sheets it shows me error.

Please Login or Register  to view this content.

my matching value is in another sheet(shtEmergencyBarcode) and fetching data in first sheet (shtMainData).

is it possible in evaluate function.

[jindon]

Try change to

Please Login or Register  to view this content.

[mohan.r1980]

Fantastic!!!

Exactly i wanted

thanks again sir.

[jindon]

Remember

Formula string in Evaluate method refers to its parent object
shtMainData.Evaluate
so, the address without sheet name should be in shtMainData.
And also have limit of 255 characters, so make it as short as possible.

[mohan.r1980]

Thanks Sir for your nice explanation.
i do remember it.