Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default vlookup

Hi, i use this formula to extract some prices (Formula is in B cell)..
(=IF(A8<"";IF(ISNA(VLOOKUP($A8;$J$1:K20;2;FALSE)) ;0;VLOOKUP($A8;$J$1:K20;2;FALSE));""))
....but i want to extract from "J" and "L". I dont want columns to be one
next to the other. My formula extract prices from "J" and "K". And i would
like database ("j" and "L") to be in another sheet.

This is my actual table (database in the same sheet):

A B... ...J K

1 product 1 100 product 1 100
2 product 3 120 product 2 170
3 product 2 170 product 3 120

....but i want to skip "K" and extract from column "J" and "L" like this
(database to be in another sheet):

A B... (another sheet) ...J
K L

1 product 1 100 product 1
100
2 product 3 120 product 2
170
3 product 2 170 product 3
120


Thanks in advance.