searching/displaying data with vlookup/index/match

[Kozemp]

Forgive me if this has been asked and answered before, but I have searched and not seen this particular problem.

I have a table of part and purchase order data - column A is part numbers and columns B-E are purchase order numbers.

Elsewhere I want to do a lookup that, for a given part number on this table, will return the first purchase order number given. (Some part numbers have multiple PO numbers, but I am only interested in the first one that appears in each row.) Ideally I would like to do this without a series of multiple nested IF(ISNA(VLOOKUP functions.

Put another way (I think) in the vlookup syntax of VLOOKUP(lookup value, array, column number, FALSE), I need to find a way to vary the column index number so as to head for the first non-blank value.

I have a sneaking suspicion I should be using a combination of INDEX and MATCH to do this, but I'm not quite sure of that, or how.

Any help is greatly appreciated.

 

[joeybantog]

Forgive me if this has been asked and answered before, but I have searched and not seen this particular problem.

I have a table of part and purchase order data - column A is part numbers and columns B-E are purchase order numbers.

Elsewhere I want to do a lookup that, for a given part number on this table, will return the first purchase order number given. (Some part numbers have multiple PO numbers, but I am only interested in the first one that appears in each row.) Ideally I would like to do this without a series of multiple nested IF(ISNA(VLOOKUP functions.

Put another way (I think) in the vlookup syntax of VLOOKUP(lookup value, array, column number, FALSE), I need to find a way to vary the column index number so as to head for the first non-blank value.

I have a sneaking suspicion I should be using a combination of INDEX and MATCH to do this, but I'm not quite sure of that, or how.

Any help is greatly appreciated.

[please try this one: vlookup(partno,A1:Dno.,2(which is the corresponding PO no. of this column) hope this will solved your problem

 

[Kozemp]

I'm sorry, that is not helpful.

 

[Aladin Akyurek]

Have a look at

http://www.mrexcel.com/forum/showthread.php?t=231882

in order to assess whether it is or can be made applicable to your problem situation.