Forum Discussion
Solved
IF this than that function in excel
Hi, I am wondering if there is a formula for the following: Column T (50 rows) represents descriptions Column V (50 rows) represents a code which is linked to the description For example: ...
=IFERROR(INDEX($V$1:$V$50,MATCH(H1,$T$1:$T$50,0)),"")You can try INDEX and MATCH. An alternative could be VLOOKUP. If you work with Office365 you can apply XLOOKUP.
=IFERROR(INDEX($V$1:$V$50,MATCH(H1,$T$1:$T$50,0)),"")You can try INDEX and MATCH. An alternative could be VLOOKUP. If you work with Office365 you can apply XLOOKUP.
YES IT WORKS!!! Thank you so much for your response!