Forum Discussion
Search formule, in table searching in 2 rows.
Hello everyone,
I want to make an automatic cell with a formule, surrounded cell with blue. I want it so it reads the cell in front, underlined blue in the table on the right, surrounded with red. the next problem is then its bases on the number in front of the comma, first column and behind the comma top row. Note this is only half of the total table! This is the biggest problem cause it is not a small table.
Hopefully someone can help me!
thanks in advance
Maybe this is what you're after. Try this rather lengthy formula out and let me know if it gives you your desired results:
In Cell G4:
=INDEX($P$4:$Y$60,MATCH(IF(ABS(ROUND($F4-ROUNDDOWN($F4,),1))=1,ROUNDUP($F4,),ROUNDDOWN($F4,)),$O$4:$O$60,0),MATCH(IF(ABS(ROUND($F4-ROUNDDOWN($F4,),1))=1,0,ABS(ROUND($F4-ROUNDDOWN($F4,),1))),$P$3:$Y$3,0))
P.S.
I would love some suggestions to help condense this formula.
