Search for client

[Oeysbrei]

Hi,

I need some help with formula to track client by typing eighter client name or number.
Samplefile attached.

Any help is very much appreciated.

Best regards

喕stein

[6StringJazzer]

The way you have it set up, you have to use a macro. I have changed your setup slightly so you can do it with formulas.

Enter either a client number or a name in E3, and the result will appear in F3.

[TMS]

Or, if you do want a macro:

Please Login or Register  to view this content.

[Oeysbrei]

Hi TMS,

I will test youre code, but the clients number and names are in another sheet that is called "Kunderegister". Clientnumber from A5 and down, and names from B5 and down.

Please Login or Register  to view this content.

I gues it is this line I have to modify, but how?


Hope to hear from you again, and thanks for all youre help so far.


Regards

喕stein

[Oeysbrei]

Thanks for youre reply 6StringJazzer, But I can not use this at my register. I will save the formula so I will be able to use it in other cases.


Regards

喕stein

[avk]

In "F2"

Please Login or Register  to view this content.

[TMS]

but the clients number and names are in another sheet that is called "Kunderegister". Clientnumber from A5 and down, and names from B5 and down.

That was not indicated in your sample workbook.

If you want a realistic solution, you need to post a realistic sample workbook. We can't make this stuff up ...

[Oeysbrei]

Thanks for youre reply, but this formula does not work. I have adjusted it for Norwegian version, but I get a message that to many functions has been used.


Regards


喕stein

[avk]

Dear Oeysbrei, can you attach your sample file with desire result. Ifs more helpful.

[TMS]

Try

Please Login or Register  to view this content.

[Oeysbrei]

Hi TMS,

I am sorry that the samplefile was not complete, but I thought that if I could get some help with the code, I would be able to modify it for my purpose.
I have attached another file that will work with my original workbook.

The original workbook contains to many personal data to post on this site.

Best regards

喕stein

[avk]

Its a circular reference warming.
But you can do : "c20"

Please Login or Register  to view this content.

"b20"

Please Login or Register  to view this content.

Note that : 1.If you're using Excel 2010 or later, click File > Options > Formulas. If you're using Excel for Mac, click the Excel menu, and then click Preferences > Calculation.

If you're using Excel 2007, click the Microsoft Office Button , click Excel Options, and then click the Formulas category.

2.In the Calculation options section, select the Enable iterative calculation check box. On the Mac, click Use iterative calculation.

[Oeysbrei]

Thx avk,

This worked perfect

Best regards

喕stein