Please check the below formula will help you
in column 3
=IFERROR(VLOOKUP(D4,$E$4:$E$19,1,0),TEXT(0,"Genera l"))
in column 4
=IFERROR(VLOOKUP(E4,$D$4:$D$19,1,0),TEXT(0,"Genera l"))
Please check the below formula will help you
in column 3
=IFERROR(VLOOKUP(D4,$E$4:$E$19,1,0),TEXT(0,"Genera l"))
in column 4
=IFERROR(VLOOKUP(E4,$D$4:$D$19,1,0),TEXT(0,"Genera l"))
Posting Permissions
Reply With Quote
Bookmarks