Previous Topic Next Topic

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
=VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29

This is my formula. It is supposed to look for person's name in a previous months report and add the current months total spent in G29 for total. The problem is when I add a new employee and their name is not in the previous report, I get a N/A instead of just the current total spent. How can I fix this please?
Related:

2 responses

Answer 1 / 2
Blocked Profile
Apr 18, 2018 at 04:25 PM
start with:
=IF(yourcode_here<>"" , yourcode_here , "not found")


Try that!
0
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0
ltlrose
Apr 19, 2018 at 02:33 PM
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?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0
Ltlrose
Apr 23, 2018 at 03:21 PM
Thank you, this did work out perfectly for me. You have saved me a lot of time.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 24, 2018 at 11:58 AM
That's great and thanks for the feedback!
0

Similar discussions

Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

2 responses
ps3 error problem 80023017 how can i fix it
siendy -
Bobstew -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Instagram caption issue
giddensg -
Rw -

7 responses