In Google Spreadsheet, I wasted time unnecessarily when I got errors even though I had set the vlookup search key part to Plain text.

Error message Error Did not find value in VLOOKUP evaluation.

The cause was the trap that it looked like it was Plain text but actually wasn’t… When I formatted it as Plain text again, vlookup worked normally.

When I told this story to a colleague, they told me:

TEXT(A1,"@")

makes it plain text.

Below is a sample of vlookup using the TEXT function.

• TEXT(A1,"@") を使った Google スプレッドシートのサンプル

My Google Spreadsheet skills are still insufficient.

That’s all from the Gemba.