Posted 27 Days Ago Job ID: 1566864 1 quotes received

Excel formula to pull from correct row

Fixed Price or Hourly
Quotes (1)  ·  Premium Quotes (0)  ·  Invited (1)  ·  Hired (1)

  Send before: August 19, 2019

Send a Quote

Administrative & Secretarial Microsoft Office Software

I have a data set for v lookup and it looks like: 

SP7000 P0001 DOLLAR AMOUNT
SP7000 P0002 DOLLAR AMOUNT
WA5001 P0001 DOLLAR AMOUNT 
WA5001 P0002 DOLLAR AMOUNT 
WA5001 P0003 DOLLAR AMOUNT 

Etc. 

I need to pull only from the last P000#. 

How can I do this? Thank you
Rachel S Afghanistan