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?

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!
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
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?
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
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.
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!

Similar discussions

Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

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

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

2 responses
Instagram caption issue
giddensg -
Rw -

7 responses