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

A	B	C	D
Serl. No	Bar code	Bar code no	Item name
BWStock00001		6001599054393	Diary
BWStock00002		6001015506017	tin
BWStock00003		6001007316884	Paper Towl
BWStock00004		6001007160937	toilet paper
BWStock00005		6001087006033	HAMMER

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

2 SHEET

A B		C	D	E	F	G
		Barcode no	Serl. no.	Item Name	Units	Price
	1
	2
	3
	4
	5
	6

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[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 ??