Hi guys, i've been trying to figure this one out.


SHEET 1

<Column A> <Column B> <Column C>
Item code Item Name Price
000001 Pencil $1
000002 Pen $2
000003 Eraser $0.50
000004 Paper $5
000005 Highlighter $2




SHEET 2

<Column A> <Column B>
IF I key in 000004 here This column to auto-appear "Paper" - please help on what formula to put here.