Find the row number of a formula's value

**xaz312** · 01-30-2023, 09:49 AM

Hello!
I know about the MATCH function, so this is not a problem which can be solved by this or other similar formulas (as far as I know).

I've got a formula which returns a value (the formula I used for returning a value is XLOOKUP). If there were to be a single instance of this value, then its row number could easily be found, but there are multiple instances of this value.

Adjacent to these values, there is a code, and these codes are different. This way I can differentiate the values. When I use XLOOKUP, the lookup value is the code, and the return array is the value's column. What is being returned is the value, but when I use MATCH, it returns the row of the first instance of the value, not the row where XLOOKUP got the value from.

English is not my main language and I hope I was coherent enough in order for you to understand my problem.
Thank you.

**Pepe Le Mokko** · 01-30-2023, 10:34 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Sam Capricci** · 01-30-2023, 10:36 AM

Are you looking to return to sell address where the value is? So let’s save the value being returned from your xlookup is located in Cell C234, is that the address you’re looking to return?

By the Way, your location listed as “the milky way“ may be clever, but it’s not helpful as Excel works differently in different areas.

Lastly, if you want something specific it would be helpful for you to upload a small sample workbook.

Find the row number of a formula's value

LinkBack

Thread Tools

Rate This Thread

Display

Find the row number of a formula's value

Re: Find the row number of a formula's value

Re: Find the row number of a formula's value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] formula to look in a number column and find a certain type of number

Formula to find out number per 100

[SOLVED] Formula required to find the nth nearest number to a selected number

Formula? to find existing use of a reference number across 12 tabs then find next avail #

Multiple prices for 1 number, need formula to find lowest price for each number

How to find from "Find and Replace" command formula generated number?

countif formula to find the occurances of a number that is greater than one number but less than another

Bookmarks

Bookmarks

Posting Permissions