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 » VLoopup not picking up data
VLoopup not picking up data
Resolved · Medium Priority · Version 2007
Sat 30 Nov 2013, 14:10Delegate Imran said...
Imran has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel Advanced - Formulas & Functions course
Excel Advanced - For Power Users course
VLoopup not picking up data
Hi,
I'm trying to do a Vloopup nested in an if statement, however I keep getting a #N/A result for it. It seems like the VLookup is not picking up the data for some reason I cannot figure out for the life of me why its not doing it. Please could you take a look if I gave you a spreadsheet and advise?
Regards
Imran
Thu 5 Dec 2013, 09:00
Edited on Thu 5 Dec 2013, 09:00Trainer Cindy said...
RE: VLoopup not picking up data
Hello Imran
Thank you for your question regarding vlookups.
Feel free to forward the spreadsheet to:
info@microsoftraining.net
Subject: Please forward to Cindy.
Kind regards
Cindy
Microsoft Office Trainer
Thu 12 Dec 2013: 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. |
Excel tip:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |
