formula other than vlookup

[Dummy Excel]

Hi All,
i have a few hundred rows of data for maintenance for trucks and the the unique data is the registration (rego) with its status
The rego could be in the column a few times as it might have a few maintenance issues. Once the maintenance issues have been fixed we change the status to "Completed"

I am currently using a vlookup to workout what is available and unavailable although the vlookup only finds the first match and displays the data. Problem i have is the first match could be "Completed" so i dont see the unavailable repairs.

Is there another formula to use apart from vlookup, or how can i change my formula to ignore the "Completed" matches?

=Iferror(vlookup(C2,Reverse!$B$1:AG2014,32,false),"Available")

Column C= rego
in reverse (lookup table), column B is the rego and column AG is the status


thanks in advance for your help
Sam

 

[Coding4Fun]

https://www.mrexcel.com/forum/excel...cal-values-into-same-colum-another-sheet.html

Check out this thread, might point you in the right direction.

Let me know if you still need help.