jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 387
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
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
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