Index comes back with no match

TPALJA

Im wanting to return the email address in my column and using this formula but it comes back with no match

=INDEX({Email address}, MATCH([Quote Request #]@row, {Quote request #},0))

Kelly Moore

Hey @TPALJA

Double-check your {Quote request #} and make sure that the reference refers to the correct column and that the entire column was selected.

Kelly

TPALJA

thanks for the tip Kelly it was my numbering that caused the issued. Its been resolved

Kelly Moore

Hey @TPALJA

Is it possible to get a screenshot of your two quote request columns. I’m wondering if smartsheet considers one of the values to be a number and the other sheet to be a textstring (that may appear to us as if it’s a number). I can tell this by whether the values are right-justified or left justified (assuming you have manually formatted)

Kelly

TPALJA

this is the sheet that Im pulling it into. I copied it from the sheet thats in white below. Im using the autonumbering function on the origin sheet.

Kelly Moore

Hey @TPALJA

Double-check your {Quote request #} and make sure that the reference refers to the correct column and that the entire column was selected.

Kelly

TPALJA

thanks for the tip Kelly it was my numbering that caused the issued. Its been resolved