I have a spreadsheet as follows:

column A column B
DEK S01 0
DEK S01 300
DEK S01 400
DEK S01 450
LIC G13 25
LIC G13 50
LIC G14 100
etc...

I am trying to write a function to return the first non-zero value in
column B of the Item in column A. So when I call the function Get_Cost("DEK
S01") it will return 300. When I call Get_Cost("LIC G13") it will return
25.

A quick way of getting the row number for LIC G13 would be a help, so I
don't have to loop so much.

DG