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

Question

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.
&nbsp;Sheet 1
ColumnA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ColumnB
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Find cell location&nbsp;from Sheet2
Wheel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C2
Trunk&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D5
Peddle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A4
&nbsp;
Sheet 2:
&nbsp;

&nbsp;

haytham amairah · Answer

Hi,
&nbsp;
You will find the best answer down below:
Dueling Excel - "Address of Matching Cells": Podcast #1641

sylvia fowler · Answer

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

Forum Discussion

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

2 Replies

Resources

Forum Discussion

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

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