is there a fast way to match my "cell content" to the "row number"

[sophiekabu]

is there a fast way to match my "cell content" to the "row number" ​

Hello guys,
please help me
is there a fast way to match my "cell content" to the "row number"? TT_TT[IMG alt="thumbnail image 1 of blog post titled











is there a fast way to match my cell content to the row number












"]https://techcommunity.microsoft.com...EC7F13D3EE/image-size/large?v=v2&px=999[/IMG]

Ex: the ones with the yellow Highlight
my "cell content" 326 matches with the "row number" 326
my cell content 337, matches with the row number 337

I want to do the same thing with cell contents 350, 353, 361, 365, 372, 380, 385, 389, 397, 402, 409 and 411

PLEASE HELP ME

 

[sophiekabu]

It wasn't at all clear to me that you need to move the content to the relevant row. (I also can't really imagine why, but that's another issue).

Is it actually just two columns of data you have currently?

I have huge pool of data and I need to double check "each" if the value matches, if there's a discrepancy or not

the contents of column A show the exact row number of the data I want my datasets be compared to

ex: code 2201305FEAFNFR is located in row number 312, putting it row 312 gives me an answer right away ~ it does have a discrepancy

312

cessybanez

1728

2201305FEAFNFR

cessybanez

1759

-31

 

[RoryA]

There are much better ways than rearranging your data. You could simply use an INDEX formula to return the value in the relevant row from the other data set. For example:

=INDEX(H:H,312)

will return whatever is in row 312 in column H.

 

[sophiekabu]

Can you please help me, I will give an example sets of data I want to match Set A with Set B ?
I'm new to Mr. Excel tho, I don't know how I'm going to upload the file

 

[RoryA]

I just gave you an example of the formula. If you are trying to match the data on the right hand side of your picture with the data on the left side, I wouldn't bother with the row numbers. I'd use something like this in K2 and then copied down:

=IFERROR(I2-INDEX(D:D,match(G2,B:B,0)),"No match")

That will lookup the code in G2 in column B and return the matching value from column D, then subtract that from the value in I2, which appears to be what you want.

 

[RoryA]

See this thread for details of how to post sample data if still required: XL2BB - Excel Range to BBCode