VLookup formula gives error
Closed
ltlrose
Posts
1
Registration date
Wednesday April 18, 2018
Status
Member
Last seen
April 18, 2018
-
Updated on Apr 19, 2018 at 11:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 24, 2018 at 11:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 24, 2018 at 11:58 AM
Related:
- VLookup formula gives error
- Network error occurred - Guide
- Cmos checksum error - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Position formula in excel - Office Software Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Updated on Apr 19, 2018 at 11:25 AM
Updated on Apr 19, 2018 at 11:25 AM
Hi Itlrose,
You ran into an error which stops the formula from working.
=IF(ISERROR(VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)),G29,=VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29)
When the VLOOKUP part creates an error the value will be G29. When it doesn't then your original formula will do it's work.
Best regards,
Trowa
You ran into an error which stops the formula from working.
=IF(ISERROR(VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)),G29,=VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29)
When the VLOOKUP part creates an error the value will be G29. When it doesn't then your original formula will do it's work.
Best regards,
Trowa
First, thank you so much for responding with a possible solution, however, when I paste the formula in the cell, Excel returns an error message, it's not seeing it as a formula. Keep in mind that I am a rookie with formulas, am I doing something wrong or could there be a slight error with the formula that Excel doesn't like?
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 23, 2018 at 11:28 AM
Apr 23, 2018 at 11:28 AM
Hi Itlrose,
Sorry, my bad, forgot to remove the second = symbol:
=IF(ISERROR(VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)),G29,VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29)
How does that work?
Best regards,
Trowa
Sorry, my bad, forgot to remove the second = symbol:
=IF(ISERROR(VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)),G29,VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29)
How does that work?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 24, 2018 at 11:58 AM
Apr 24, 2018 at 11:58 AM
That's great and thanks for the feedback!
