Match & Index to return the cell location of a matching value

Highlighted
New Contributor

I have a complex request to look up a value from one spreadsheet on another and return the cell location of the value on the second spreadsheet. I am open to other functions to accomplish this in the simplest manner.

 Sheet 1

ColumnA            ColumnB

                            Find cell location from Sheet2

Wheel                   C2

Trunk                    D5

Peddle                  A4

 

Sheet 2:

 

Capture.PNG

 

2 Replies
Highlighted
Highlighted

Thank you....That worked PERFECTLY!!!!!!