TRIM & Vlookup

[Dummy Excel]

Hi All,
is it possible to incorporate the trim & vlookup formula into one??

thanks
Sam

 

[VBABEGINER]

Yes, lets try this, even i am trying

=Trim(Vlookup("select cell where u require answer", "select table from where u require data", "provide the column index", "False" - for exact value)

 

[VBABEGINER]

I am trying,, but not possible

 

[prajul89]

Which data you want to trim
the Ans form Vlookup or Arg1 of the Vlookup???

 

[Dummy Excel]

both trim and vlookup is for arg1

 

[prajul89]

=Vlookup(Trim(A1),C:D,2,0)


where A1 is your Agr1
C:D is your Table
2 is the no of column i.e, D column
and 0 represents False

 

[Dummy Excel]

thanks prajul - i just figured it out myself also :0