Hi Brian

What I was trying to do was to turn the lookup result in multiple worksheets into value.

For my first code above, somehow, it works on all the selected worksheet except the last one.

For the second code, when I included code ".Value = .Value" (highlighted in read above), the return value is empty in A7. When I removed it, the result can be displayed but this couldn't meet my requirement (i.e. turn the lookup result in multiple worksheets into value.)