Forum Discussion
Help pulling row information from a list using IF
I'm trying to pull information from a row in a separate sheet using if to see if it meets the criteria within a column. e.g. if a cell in column A = 3, I then want it to show the information from col...
Thanks for your help SergeiBaklan. Now I understand and yes, I would like only the element with the result using the condition TRUE to be displayed. What formula should I be using for this?
Formulas could be different, also depends on your version of Excel. This one shall work in any case
=INDEX('202022'!$K$2:$K$36,MATCH(140807,'202022'!$D$2:$D$36,0))
Better keep lookup value in the cell, let say A1
=INDEX('202022'!$K$2:$K$36,MATCH(A1,'202022'!$D$2:$D$36,0))