Forum Discussion

Testbot1's avatar
Testbot1
Copper Contributor
Jul 25, 2023
Solved

Vlook up Error

Hi Community,  I'm trying to do a vlookup to capture  the values from my second sheet( Values). This is the formula I used below. Ideally, I want the C column on the master sheet to read Rejected,...
  • Riny_van_Eekelen's avatar
    Jul 25, 2023

    Testbot1 The lookup values (column A on the Master sheet) are a mix of texts and numbers. Text "17" is not equal to number 17, hence #N/A#

     

Resources