LOOKUP Help needed

[Paul Watkins]

Hi
On Sheet 1 of a workbook i have 4 columns of information
Item Number (Column A)
Description (Column B)
Price (Column C)
Location (Column D)

In Cell K1 i want to select from a combobox the description 'Ice Cream' and
then have Cell L1 display the corrosponding Price Cell M1 display the
location and Cell N1 display the item number for the Ice Cream.
I have this formula in cell L1 =[IF(K1="","",VLOOKUP(K1,b3:c40,2,FALSE))]
This displays the price.
I've tried the formula below in cell M1 but i get '#N/A' in the cell.

IF(K1="","",VLOOKUP(K1,A340,1,FALSE))

How can i get this lot to work


Thanks in advance

Paul

 

[Ron de Bruin]

Hi Paul

You description is in column B

This formula is looking in A

IF(K1="","",VLOOKUP(K1,A340,1,FALSE))

It looks in the first column of the range

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

Hi
On Sheet 1 of a workbook i have 4 columns of information
Item Number (Column A)
Description (Column B)
Price (Column C)
Location (Column D)

In Cell K1 i want to select from a combobox the description 'Ice Cream' and
then have Cell L1 display the corrosponding Price Cell M1 display the
location and Cell N1 display the item number for the Ice Cream.
I have this formula in cell L1 =[IF(K1="","",VLOOKUP(K1,b3:c40,2,FALSE))]
This displays the price.
I've tried the formula below in cell M1 but i get '#N/A' in the cell.

IF(K1="","",VLOOKUP(K1,A340,1,FALSE))

How can i get this lot to work


Thanks in advance

Paul

 

[Paul Watkins]

Thanks Ron
I get 'formula blind' from time to time

Paul

Hi Paul

You description is in column B

This formula is looking in A

IF(K1="","",VLOOKUP(K1,A340,1,FALSE))

It looks in the first column of the range

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

Hi
On Sheet 1 of a workbook i have 4 columns of information
Item Number (Column A)
Description (Column B)
Price (Column C)
Location (Column D)

In Cell K1 i want to select from a combobox the description 'Ice Cream' and
then have Cell L1 display the corrosponding Price Cell M1 display the
location and Cell N1 display the item number for the Ice Cream.
I have this formula in cell L1 =[IF(K1="","",VLOOKUP(K1,b3:c40,2,FALSE))]
This displays the price.
I've tried the formula below in cell M1 but i get '#N/A' in the cell.

IF(K1="","",VLOOKUP(K1,A340,1,FALSE))

How can i get this lot to work


Thanks in advance

Paul