The code below will iterate through each row and cell in the table till it finds the PON that matches strMyPON (the known purchase order number), then it will capture the CIN that is on the same row.
strMyPON = ''12345''
Set MyTable = Browser(''yourbrowser'').Page(''yourpage'').WebTable(''yourwebtable'')
intRows = MyTable.RowCount 'counts the rows in the table
For intCurrentRow = 1 To intRows 'Begin looping through every row in the table
strCIN = MyTable.GetCellData(intCurrentRow,1) 'Capture the CIN value for row intCurrentRow
strPON = MyTable.GetCellData(intCurrentRow,4) 'Capture the PON value for row intCurrentRow
If trim(strPON) = strMyPON Then 'Verifies if I found the PON I wanted. Trimming any possible leading or trailing spaces which are common.
Exit For 'If I found the right PON, then exit the for loop and move on with the test.
msgbox ''I found the CIN for '' & strPON & ''!! It is '' & strCIN