Hi,
I have used formula in J column of 'result' worksheet but it is not working.
One more most important thing is that if any row is blank in pt worksheet (i.e A7) then the data just above that blank row (i.e A6) result should create an error or blank in result worksheet (i.e in K23)
Sample result is stated in K column.I have used formula in J column of 'result worksheet which needed improvement as it is not pulling.
I have posted at https://www.excelforum.com/excelgeneral/1245319vlookupandsubstitute.html#post4973888
Still the result is not received.
I have used formula in J column of 'result' worksheet but it is not working.
One more most important thing is that if any row is blank in pt worksheet (i.e A7) then the data just above that blank row (i.e A6) result should create an error or blank in result worksheet (i.e in K23)
Sample result is stated in K column.I have used formula in J column of 'result worksheet which needed improvement as it is not pulling.
I have posted at https://www.excelforum.com/excelgeneral/1245319vlookupandsubstitute.html#post4973888
Still the result is not received.
Attachments

13.5 KB Views: 11