98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » If vlook up formula
If vlook up formula
Resolved · Medium Priority · Version 2010
Wed 29 Apr 2015, 13:50Delegate Jelena said...
Jelena has attended:
Excel Advanced course
If vlook up formula
Hi.
Would I be able to upload the document for you to see the formula in use?
I can't figure out why formula doesn't work.
=IF(ISNA(VLOOKUP(A16,B_table1,FALSE)),"", VLOOKUP(A16,B_table1,2,FALSE))
Wed 29 Apr 2015, 15:15Trainer Richard said...
RE: if vlook up formula
Hello Jelena,
Hope you enjoyed your Microsoft Excel Advanced course with BEST Training.
Thank you for your question regarding VBA.
If you can send your file through to forum@stl-training.co.uk we can take a look at your question for you.
Kind regards,
Richard
Wed 29 Apr 2015, 16:43Delegate Jelena said...
RE: if vlook up formula
Hi Richard,
I can't see how to upload the file?
I can only submit the question.
J
Thu 30 Apr 2015, 09:25Trainer Richard said...
RE: if vlook up formula
Hi Jelena,
You are not able to upload a file. Please would you email it to forum@stl-training.co.uk.
Kind regards,
Richard
Fri 1 May 2015, 10:39Trainer Richard said...
RE: if vlook up formula
Hi Jelena,
I believe you are typing in the Cons Codes and wish to Lookup the Description?
If the Cons Code is left blank rather than getting #N/A you want it to display a blank?
If so try this
=IFERROR(VLOOKUP(A16,B_table1,2,FALSE)," ")
Your first Vlookup formula was missing the Col Index Number
The ,"", doesn't create a space you need ," ",
Please let me know if that works, or if you would like the corrected file sent back to you.
Kind regards
Richard
Microsoft Office Specialist Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 6 May 2015, 10:47Delegate Jelena said...
RE: if vlook up formula
Hi Jelena,
The formatting on B16 was Text not General
I think that's why the formula was displaying and not working.
I will send you an email with the adjusted file.
Kind regards
Richard
Microsoft Office Specialist Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 6 May 2015, 10:59Trainer Richard said...
RE: if vlook up formula
Hi Jelena,
The formatting on B16 was Text not General
I think that's why the formula was displaying and not working.
I will send you an email with the adjusted file.
Kind regards
Richard
Microsoft Office Specialist Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 13 May 2015: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
