Excel rows not getting filled dynamically

i am trying to look up values of column C from column A and get respective column B values in column D. So for this i am using this formula in D1 : =VLOOKUP($C$1,$A$1:$B$5,2,FALSE)

When i am dragging it i am getting the same formula being copied in subsequent cells and hence the same result.

P.S calculations options is set to Automatic.

if image is not appearing then: https://1drv.ms/i/s!AnK28ghvsJNz0VAwB24jdGkunQA7

By: Shivam

Leave a Reply

Your email address will not be published. Required fields are marked *