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))
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
RE: if vlook up formula
Hi Richard,
I can't see how to upload the file?
I can only submit the question.
J
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
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
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
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
