Inventor - barcode formula help

[frankishk]

I have barcodes (master files) in column c and descriptions in column d and I have a scanner for inventory purposes which scans the barcode and quantity. I have pasted the scans with the quantities into this sheet and What I need to do is make a formula eg in column f that says if the barcode in column g matches the barcode in column c then put the qty in - col h.

Any help appreciated
Kim

Column
a B C D E F G H
Master Stock Qty
Barcode Barcode on
Stock

G & H are colum I have pasted in to this spread sheet from my scanned data....
What I want column D to do is lookup cell eg c1 and matchthis by looking up colum G and then put the corresponding qty (col H) in here.

Eg if C4 equals G22 then put the value of H22 in D4

Hopefully that make sense

[anvidc]

Hi,
I assume that you are using Excel 2007 above

You can use SUMIF

=SumIF(G:G,"=" & C2,H:H)
 

[frankishk]

Can you please look at my update as I couldn't get the formula you posted to work - but it looks close

[anvidc]

Hi,

I not sure how's your Scan Data will look like. My guess you need to sum all your scan quantity, if this case

=SUMIF(G:G,"="&C:C,H:H)

if you need just lookup the match

=VLOOKUP(C:C,G:H,2,FALSE)

but this will only lookup the first match

to better understand you can upload some sample data here..

[frankishk]

THnaks , that formula was correct and I got it to do what I needed, thanks heaps for your help!!