Hi Everyone,
Hope all doing well and safe!!.
I just need a help for excel formula.
Actually am comparing two values with vlookup with one reference sheet and one input sheet.
Am doing vlookup from my reference sheet towards input sheet. If any value changes done on input that should be updated on reference sheet also in some case if no values provided on input then result should not returns with not empty it should return as value which is available on reference sheet.
Formula which i used : - =VLOOKUP(A3,Input!A:B,2,0)
I have attached sample IMAGES for better understanding.
Thanks a lot in advance.
Hope all doing well and safe!!.
I just need a help for excel formula.
Actually am comparing two values with vlookup with one reference sheet and one input sheet.
Am doing vlookup from my reference sheet towards input sheet. If any value changes done on input that should be updated on reference sheet also in some case if no values provided on input then result should not returns with not empty it should return as value which is available on reference sheet.
Formula which i used : - =VLOOKUP(A3,Input!A:B,2,0)
I have attached sample IMAGES for better understanding.
Thanks a lot in advance.