I am trying to formulate a VLookup where it pulls the rate from sheet 2 if A2 contains "CR". (Colum A is locations, ie. CR-1, CR-2, etc).
I'm using =IF(A2="CR*",VLOOKUP(B2,Rates!$A$3:$B$6,2,TRUE)) but no luck. It works if A2 is exactly "CR", but not as CR-1.
Inventory.xlsx
Bookmarks