If vlook up formula

Resolved · Medium Priority · Version 2010

Wed 29 Apr 2015, 13:50 Delegate 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:15 Trainer 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:43 Delegate 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:25 Trainer 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:39 Trainer 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:47 Delegate 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