right now i'm using this formula to refer A4 first word, that word it's actually a code. "R034".

=IFERROR(VLOOKUP(LEFT(A4;FIND(" ";A4)-1);[templateInventory2014.xlsx]Inventory!$A$7:$F$601;3;FALSE);"")


I want to use similar formula but to count +1 every time R034 it's referred. like on the above formula "(LEFT(A4;FIND(" ";A4)-1)"


Because on the cell i have also other data: "R034 telecom switch"