vlookup function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup function

Vlookup function

resolvedResolved · 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.


 

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips


Server loaded in 0.08 secs.