Query related to Lookup data

Hello Friends,

I have to paste data 4 times one by one in Web data column and want output in status columns.

  • 1st time- I insert data in web data column and using another sheet for lookup data and I paste in status column
  • 2nd time I insert data in web data column which is lesser than 1st time then my lookup data giving result but more than data as you see in screenshot.
    I want output like in 2nd screenshot.

Pls help
This comes when my 2nd lookup runs.

Output required like this:-

@Jeeru_venkat_Rao When you insert the second set of data in Web Data, is it different from the first time you pasted?


Yes bro, data is differ