EXCEL Sheet and blocks

[Gideondb]

1. In excel 2013 , can you scan a barcode so that that barcode takes you to n spesific block A1 on a specific sheet. ?

2. In the first sheet i have in colum A serl. no.s , in colum C a bar code no.s and in colum D a Name.In another Sheet i scan items in RANDOM BARCODES , I want the name and serl. number to appear in the blocks next to it from sheet 1 ?

1 SHEET

[TABLE="width: 458"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD] A[/TD]
[TD] B[/TD]
[TD] C[/TD]
[TD] D[/TD]
[/TR]
[TR]
[TD]Serl. No[/TD]
[TD]Bar code[/TD]
[TD] Bar code no [/TD]
[TD] Item name[/TD]
[/TR]
[TR]
[TD]BWStock00001[/TD]
[TD][/TD]
[TD]6001599054393[/TD]
[TD] Diary[/TD]
[/TR]
[TR]
[TD]BWStock00002[/TD]
[TD][/TD]
[TD]6001015506017[/TD]
[TD] tin[/TD]
[/TR]
[TR]
[TD]BWStock00003[/TD]
[TD][/TD]
[TD]6001007316884[/TD]
[TD] Paper Towl[/TD]
[/TR]
[TR]
[TD]BWStock00004[/TD]
[TD][/TD]
[TD]6001007160937[/TD]
[TD] toilet paper[/TD]
[/TR]
[TR]
[TD]BWStock00005[/TD]
[TD][/TD]
[TD]6001087006033 [/TD]
[TD] HAMMER

[/TD]
[/TR]
</tbody>[/TABLE]
2 SHEET

[TABLE="width: 519"]
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD] A B[/TD]
[TD][/TD]
[TD] C[/TD]
[TD] D [/TD]
[TD] E[/TD]
[TD] F[/TD]
[TD] G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Barcode no[/TD]
[TD]Serl. no. [/TD]
[TD]Item Name[/TD]
[TD]Units[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Gideondb]

GOT IT THANK YOU ALL =IF(ISBLANK(C3);""; INDEX(StockMain!A:A;MATCH(C3;StockMain!C:C;0))) MY block is C 3 . Thank you Thank you .I have some more ill place a new tread.Thank you so much Bobsan42 , Mark858.

 

[Gideondb]

I want the stock name in my sheet 2 Donnie to appear as well , I tried this BLOCK E3 Sheet Donnie =IF(ISBLANK(C3);""; INDEX(StockMain!A:A;MATCH(D3;StockMain!D:D;0))) The stock name is in D3 in sheet 1 my StockMain . Does not work ?#N/A Can you help please.

 

[bobsan42]

sorry for not being utterly clear but i left it to you to sort out the ranges since you have your worksheet in front of you. Also formula separators are up to you to sort out.
If you want to get the value from D you must understand the formula.
This is the way you should type the formula in E3:

[COLOR=#333333]=IF(ISBLANK(C3);""; INDEX(StockMain!D:D;MATCH(C3;StockMain!C:C;0)))[/COLOR]

INDEX tries to find the relative position of the barcode in column C on StockMain.
MATCH takes this position and return the value in the same location in column D on StockMain.
So you should not change what is in the INDEX brackets.

 

[Gideondb]

Thank you Thank you I really appreciate your help . Can you work with Macros ??