Hai guys,
Please help me out
i have a data like the below
DocumentNo ReferenceNo
14000 15000
15000 90000
16000 14500
14500 17000
18000 17000
16500 17000
90001 16500
now what i want to know is
if i give documentNo as lookup_value and above table as lookup_table and Series=9 then i should know for that document what is the corresponding
9 series document
for e.g if i give 14000 as my lookupvalue i should get 90000 as my result
if i give 14500 as my lookupvalue i should get 90001 as my result
for doing this
UDF should look like this
=klookup(lookupValue, LookupTable, Series,Occurence)
Regarding occurence for one document u may have more than one result
can anybody helpme out please
Thank u in advance
please help me out
xlkoti