Match Question

[CWatsonJr]

I am using the Match function to find the row in which a number appears and it isn't acting as I think it should. I know I'm making some kind of dumb error, but I haven't been able to figure out what it is.

I have attached a sample sheet. The Match statement is in column G and it should be finding the row in which the number from column F appears in Column D.

I am doing this to eventually be able to sort column A from highest to lowest and not worry about duplicate numbers.

Thank you for any assistance.

[Paul]

Looks like you're just missing the last parameter of the MATCH function to determine if you want an exact match or not. Try:

Please Login or Register  to view this content.

[CWatsonJr]

Thank you Paul! I knew it was something simple I was overlooking.