Hi All…
I have a 2 excel sheet which is look like I have shared an image below. so, I have to compare 1st column from the 1st sheet and 1st column from the 2nd sheet. if it’s matched, I have to get the value from the 2nd column from 1st sheet and past it to the 3rd column to the 1st sheet. if it’s doesn’t match the value should be blank. (I have attached the image for reference. please find that)
I have to use linq because of huge data.
TIA!..