Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |