Hi I hope someone can finally solve this for meas I have ran out of ideas.

I have the following spread sheet which has asearch form attached,

If I enter an engineer number in it from theengineer column it will search the fields and show me if that eng is in and ifnot who is covering. However I have x2 problems, 1 is that on certain resultsit returns 0 if there is no info instead of NA. so how can this be addressed.

And the 2[SUP]nd[/SUP] problem is as follows.

In the covering engineer column. Some engineerscan cover more than one engineer see example engineer 7106 you can see that hecovers 2 areas. What I would like to happen is a formula that I can enter intoa cell to show the following.

If I entered 50007106 it would still show thatthe original area eng 7112 and 7106 is covering but I need it to show the otherarea that 7106 also covers which is 50007384.

Hope this make sense.

So ideally it would match what is in thecovering eng column and return the values or value in the covering eng columnas well as comments etc. can this be done. I have tried look up but found theindex match side of things better as it looks left and right where by vlook updoes not.

I have the following spread sheet which has asearch form attached,

If I enter an engineer number in it from theengineer column it will search the fields and show me if that eng is in and ifnot who is covering. However I have x2 problems, 1 is that on certain resultsit returns 0 if there is no info instead of NA. so how can this be addressed.

And the 2[SUP]nd[/SUP] problem is as follows.

In the covering engineer column. Some engineerscan cover more than one engineer see example engineer 7106 you can see that hecovers 2 areas. What I would like to happen is a formula that I can enter intoa cell to show the following.

If I entered 50007106 it would still show thatthe original area eng 7112 and 7106 is covering but I need it to show the otherarea that 7106 also covers which is 50007384.

Hope this make sense.

So ideally it would match what is in thecovering eng column and return the values or value in the covering eng columnas well as comments etc. can this be done. I have tried look up but found theindex match side of things better as it looks left and right where by vlook updoes not.

#### Attachments

Last edited by a moderator: