hi
i got as far as to realize that index and match shouldnt have empty rows. i used power query to trim and clean so values are the same
index and match works but leaves me a messy sheet full of #NA
=INDEX('Vendors with Addresses'!A:A,MATCH([@[Tabs ID]],'Vendors with Addresses'!M:M,0))
how do i add custom message that if result is #NA instead "choose another method"
i got as far as to realize that index and match shouldnt have empty rows. i used power query to trim and clean so values are the same
index and match works but leaves me a messy sheet full of #NA
=INDEX('Vendors with Addresses'!A:A,MATCH([@[Tabs ID]],'Vendors with Addresses'!M:M,0))
how do i add custom message that if result is #NA instead "choose another method"