Using Vookup to find value or Match?

Hi,

can anyone help.

What I am trying to do in theory sounds simple to me but I just cannot figure out how to do it.

I have a part number and I need it to lookup through four sheets (this i have done through vlookup) so on the sheet I have the part number and four fields, in which one has the correct code against it. I need to put only the found code to the end so it can be copied into another sheet. But i cannot think of how to do this.

the N/A's are a result of a nil find on the Vlookup so are formulated.

I need to be able to put the found result in a new column at the end regardless of which lookup finds it.

Hope this makes sense.

Thank you.

I think LianCragg has the following:

4 cells, 3 of which are errors (#N/A), only one of which is a value.

I then believe LianCragg wants a separate cell that looks in the 4 cells and prints only the one that has a value, whichever one that is, and i presume that can change..

Not sure myself on how to do it, but think that explanation might help..

Hi,

This is a very simplified version but i hope you get the gist.

Your help is very much appreciated.

Lian.

how daft is that, this is an excel help forum but you cannot attach an excel sheet???

Hi Sweep,

no that formula didn't work. Please take a look at the example?

Thank you.

Lian

Example.zip

oopsy

Try using the same formula that Sweep used except in place of the 0 use ""

=INDEX(A1:D1,MATCH("",A1:D1,-1))

For cell M2 in your example replace A1:D1 with C3:F3, for cell N2 replace
A1:D1 with H3:K3.