how to find(vblookup) but part of the value

[jamiguel77]

hi all.

hi have this sheet:

https://imgur.com/a/qCbFd

specially see D5 AND D6 cells (the value)..

also i have this other sheet (same book):

https://imgur.com/a/1ql4J

see the value in cell: A2, A3, A4

in A2 have the value: P678 if try find it in my sheet1: https://imgur.com/a/qCbFd this value is located in D9 right? how to get the value in C9 and A9 and store it in: my sheet 2: https://imgur.com/a/1ql4J (same as the image)

in the case of the value of A3: H300 this value is on sheet1 in cell: D5 but if you see the content of this cell is: T226 H300 how do the work?
in the case of the value of A4: J 304 this value is on sheet1 in cell: D5 but if you see the content of this cell is: T226 H300 how do the work? if you see J 304 have a space, need remove first and try lookup.

thanks

 

[steve the fish]

I dont know your sheets so will need some adjustment but maybe like this:

=INDEX(Sheet1!$A$1:$A$100,MATCH("*"&SUBSTITUTE(A2," ","")&"*",Sheet1!$D$1:$D$100,0))

 

[jamiguel77]

Done! worked.....

Thanks