Searching

Hi friends

i need a help. At attachment, i want to searh from data sheet by writing a formule to black area.

We will write id number to yellow area.

When we write value to yellow area, the formule in black are will look column of " d ".

If it is " machinery" or " with lifting point " , the formule will search only according to id number.

If it is " lifting gear ", the formule will search according to id number and capacity simultaneously. And the value will be come up in black area from column of "a".

If there is no id number in data sheet, " no certificate no" will come up im black area.

Thank you for help

Hi,

Can you be more explicit when you say for lifting gear you search according to 'ID and capacity simultaneously'. Can you give an example? Are you for instance entering say GR25 in D18? And the follow on question is if so, do you need to since in the example all the lifting gear IDs are unique irrespective of the capacity?

Regards

Hi,
One way,
Add another helper column G to the Data Sheet. In G2 enter

Please Login or Register  to view this content.

and copy down

Now in J24 of your searching page

Please Login or Register  to view this content.

HTH

Hi,

See attached. You had changed the name of the 'Data Sheet' to 'Data' without also changing the formula I gave you. In addition you hadn't copied G2 down to G30.

Regards