VLOOKUP No Longer works with same formula

AaronVersch

This worked right before New Year's. Now for some reason it says Incorrect Argument Set?=VLOOKUP(Email@row, {RRFP Sales Log 2025 Total Cost}, 13, false)

Basically I have the clients' email in the Primary Column for Smarthseet 1 and 2.

I sheet 2 is RRFP Sales Log 2025 and Total Cost is the name of Column I need pulled from that sheet in my current sheet.

Total Cost is 13 rows after Email and I want the exact match.

Why has this stopped working in between New Years' and January 2nd? Now it shows the #Incorrect Argument Set error message.

It doesn't help that in Smartsheet the "Reference Another Sheet" link now has a Page is No Longer Working message, making me believe this is a Smartsheet error that is going on 2-3 days….

Thanks

=Chris Palmer

Hello AaronVersch,

The error message you're receiving, "Page is No Longer Working", suggests there could be an issue with the external reference to the RRFP Sales Log 2025 sheet. This can happen if:

• The referenced sheet was deleted or renamed.
• The sheet was moved or the access permissions changed.
• Smartsheet server issues may be causing temporary disruption in accessing the external sheet (which seems to be the case based on the timing).

What to do:

• Check the Link: Open the RRFP Sales Log 2025 sheet manually and verify that it exists and is accessible.
• Check the Reference: If the sheet was renamed or moved, the references in your formula may no longer work. Ensure the {RRFP Sales Log 2025 Total Cost} reference is correct and reflects the new location/structure of the sheet.
• Permissions: Ensure you still have the necessary permissions to access the referenced sheet. If permissions were changed, you might not have access anymore.
• Wait for Smartsheet Service Recovery: If Smartsheet is experiencing a temporary service issue, it may resolve after some time.

Consider using INDEX MATCH instead of VLOOKUP:
=INDEX({RRFP Sales Log 2025 Total Cost}, MATCH(Email@row, {RRFP Sales Log 2025 Email}, 0))