Microsoft Excel - How do I find a value of 24 in column H and return the answer from the same row, Column C

Asked By Jamie Hubler on 14-Dec-12 02:03 PM
John D replied to Jamie Hubler on 14-Dec-12 04:16 PM
Hi
Use Index/Match something like this :=INDEX(C1:C180,MATCH(24,H1:H180,0))
The number 24 could be a cell reference instead