I need to connect information from different sheets in the same workbook.
I have a table in sheet 1, which have a table. First column has equipements, for example.
In sheet 2 I have a list of them, like 1 (in B3) --> phone (in C3).
Now, I do I associate the word "phone" to the that number 1, and how can I make it up to input number 1 in equipment column and it appears the word "phone" ?
