98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup function
Vlookup function
Resolved · Low Priority · Version 2007
Hugh has attended:
Excel Advanced course
Vlookup function
i believe that the anwers are provided to the practice activities, which would anser my quesion, but here is my question nonetheless:
It relates to question 3 of Unit 2 Pactice activity. I could not work out how to keep the cells blank until a product code is selected. the formula i used, which did not work was:
=VLOOKUP(IF(A16<>" ",A16," "),Product_list,3,FALSE)
I was trying to say that, if there was no blank, then give me the value in that cell, otherwise give me a blank. this did not work.
Also, i was looking for the function 'ISBLANK', which used to return an empty cell, but this did not appear when i searched through the available functions.
RE: Vlookup function
Hi Hugh
Although you had the right idea you switched the functions.
The correct way to write the function is as follows
=IF(A16="","",VLOOKUP(A16,Product_list,3,FALSE))
In other words you only run the VLOOKUP if the target cell has data in it
Regards
Carlos
Thu 27 Nov 2008: 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:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |