Multiple If Statement on a Vlookup

[bspence]

Hello, need help and struggling with a multiple If statement on a vlookup

=IF(VLOOKUP(A7,'Stock Planning - All Orders on MOM By Line Not Shipped.csv'!$C:$F,4,0)="BO","No","Yes")

I want to also include if the vale in the lookup is PB as well as BO,

How do i do this?

 

[bspence]

Thanks! Perfect, apart from it only checks the first one, but that order number has multiple lines, i need it to find anything in that where the BO or PB Is found

 

[bspence]

This part does that:

FIND(VLOOKUP(A7,'Stock Planning - All Orders on MOM By Line Not Shipped.cvs'!$C:$F,4,0),"BOPB")

By finding the VLOOKUP term in the string "BOPB", i.e. if "BO" matches any part of "BOPB" or "PB" matches any part of "BOPB", returning the position number of the match (1 or 3).It returns 0 if no match with the IFERROR wrapped around it, then you test if the value is greater than 0 ("Yes") or not ("No").

It works on filling cells A1:A3 with "BO", "PB", "AB" and running that part of the formula against it returning values of "Yes", "Yes" and "No" respectively.

This works but only for the first item it finds in the vlookup and not all items found, some of the same lookups have the same lookup number in 20 rows, some with BO, some with PB, how can i get it to look at all of them?

 

[bspence]

Hey

Can anyone else help on this?