Search and find latest revision

  • Thread starter Thread starter selts
  • Start date Start date
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
 
=vlookup(searchdoc,'Transmittal to BSF'!$A$1:$Z$9,revisioncolumn,0)
=vlookup(searchdoc,'Transmittal to BSF'!$A$1:$Z$9,datecolumn,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

determining latest duplicate 2
Find max value in one column based on another column 12
Lookup / return latest date in range AND value of 1 column to the 3
Show latest date 4
Latest date with condition 6
How to select the latest revision number record 4
How to sum up the value in column based on a 5 day week period? 1
Find variable unique text within a string 5

Back
Top