Maybe this...hello all. please help me out with this.
in sheet1 I have a data with 13digit barcode.
and in sheet2. I have only last 6digit of the barcode.
Can I use vlookup for this thing? vlookup 6digit to the 13digit barcode.
Thanks for help
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2 | 1234567111111 | A | _ | 333333 | C | ||
3 | 4789561222222 | B | _ | _ | _ | ||
4 | 3698751333333 | C | _ | _ | _ | ||
5 | 9987589444444 | D | _ | _ | _ | ||
Sheet1 |
If you trying to compare One column...then you can use..
=Vlookup(lookupvalue,right(tablearray,6),1,0)
Eg: =VLOOKUP(C4,RIGHT($A$1:$A$17,6)+0,1,0)
Don't 4et to hit CTRL+shift+Enter
Hope this will help you..!
Maybe this...
Sheet1
A B C D E 2 1234567111111 A _ 333333 C 3 4789561222222 B _ _ _ 4 3698751333333 C _ _ _ 5 9987589444444 D _ _ _
<tbody>
</tbody>
This array formula** entered in E2:
=INDEX(B2:B5,MATCH("*"&D2,A2:A5&"",0))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Maybe this...Many thanks. can you edit it abit more. I would a full barcode on column E then F the describtion
=INDEX($A$1:$A$1000,MATCH("*"&D1,$A$1:$A$1000&"",0)) is it correct?
Maybe this...
=INDEX($F$1:$F$1000,MATCH("*"&D3,$E$1:$E$1000&"",0))
Still array entered!
Sorry, I don't understand.
I'm logging off for the night. I'll check back tomorrow.