formula to allocate serials no list from a unique list to a another sheet

[JEAN1972]

I have a workbook with 2 sheets --- po sheets and serials sheets .

In po sheets column A with po numbers and column B represents the data that need a match from sheet serials sheets column A .

If match then allocate to corresponding po sheets column B .

However there are different po numbers which may have the serials no .

Looking a formula to allocate

[Hydraulics]

I think this may be the formula you are looking for:

=INDEX('SERIAL SHEET'!$A$2:$B$38,MATCH('PO SHEET'!A2,'SERIAL SHEET'!$A$2:$A$38,0),2)

[FlameRetired]

Another way.

Please Login or Register  to view this content.