Forum Discussion
Testbot1
Jul 25, 2023Copper Contributor
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,...
- 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#
Riny_van_Eekelen
Jul 25, 2023Platinum Contributor
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#
mathetes
Jul 25, 2023Silver Contributor
I missed that mix....