Search and find latest revision

S

selts

hi all,
Need to know the function to perform the following objective.
1) Find from another sheet called "Transmittal to BSF" this document
PL-0009.

2) Find the latest revision. The array should be
A,B,C,D,E...00,01,02,03,04,05....

3) find the date of issuance etc in the same row.

Please help.
thanks
 
L

Landxlii

=vlookup(searchdoc,'Transmittal to BSF'!$A$1:$Z$9,revisioncolumn,0)
=vlookup(searchdoc,'Transmittal to BSF'!$A$1:$Z$9,datecolumn,0)
 
Top