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

vlookup function

ResolvedVersion 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:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.