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

[Sylvia Fowler]

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:

[#2]

Hi,

You will find the best answer down below:

Dueling Excel - "Address of Matching Cells": Podcast #1641

[#3]

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