OK I'm loving these new formulas but I need help with the MATCH formula. I have column A with serial numbers in it. I want to scan serial numbers into column B and use the MATCH formula to match it to column A. How would you write the formula?
MATCH returns an number, not the actual value.
To do that, you need to add it to INDEX.
I'm not sure what you expect to get from the two columns.
Can you post a screen shot?
Craig
Stephanie's problem has been resolved.
She was looking to use the MATCH function to find the position in the column and then translate that into the row number. She wasn't looking to retrieve any other information (which would require using the INDEX function)
So we just added the table's offset to the number returned by the MATCH function and Bob's your uncle.
