Vlookup partial and full

[laam090]

I have data like
column1 sheet 1
11456
11248
11369
11456e
11248e
11369c
11489

Column 1 sheet 2
11456
11369
11248
I used vlookup to get value of column 1 sheet 2 but it gives only for those which doesn't have e and c at last.. How can i use one formula and get the column 1 sheet value in those which have c and e at last also??

 

[ellison]

him have you tried somethinh like this..

=VLOOKUP("*"&A40&"*",$E$40:$F$55,2,FALSE)

i.e. add in "*"& and / or &"*"

Good luck

 

[laam090]

thank you for the response but it is showing error, it is not working

 

[rlv01]

Maybe something like this

=IFERROR(VLOOKUP(A1,Sheet1!$A$1:$A$7,1,FALSE),VLOOKUP(A1& "*",Sheet1!$A$1:$A$7,1,FALSE))

 

[laam090]

this is not even working at all