Hi I have a problem with a formula returning #n/a when value is not found
{=INDEX(Sheet1!$A$1:$A$31,MATCH(1,IF(Sheet1!$D$1:$D$31=D3,IF(Sheet1!$E$1:$E$31=$D$1,1)),0))}
Thanks in advance
Hi I have a problem with a formula returning #n/a when value is not found
{=INDEX(Sheet1!$A$1:$A$31,MATCH(1,IF(Sheet1!$D$1:$D$31=D3,IF(Sheet1!$E$1:$E$31=$D$1,1)),0))}
Thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks