help with V Look up

Good day

Is there a formular that allows me to extract a report that contains the account code and value for each project. I tried =if(A1:A6=B, Vlookup(3000,A1:C7,2,0)

But its not giving me the answer i need

Project Account Code AMOUNT
A 3000 456
B 3000 556
A 4000 656
B 4000 756
A 5000 856
B 5000 956
A 6000 1056
B 6000 1156

By: Stuwart Musekiwa

Leave a Reply

Your email address will not be published. Required fields are marked *