Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP, if same data then nothing
hi, have couple of samples of VLOOKUP using, cannot quite figure out what to
use to make item equal nothing if the data is the same in both sheets. samples have a (cntrl-shift-enter array formula) thanks =IF(OR(AQ7={"","."},ISNA(VLOOKUP(AQ7,[file.xls]sheet!$AP$1:$CI$3355,(COLUMN(CI1)-COLUMN(AP1))+1,FALSE))),"",VLOOKUP(AQ7,[file.xls]sheet!$AP$1:$CI$3355,(COLUMN(CI1)-COLUMN(AP1))+1,FALSE)) =IF(OR(AQ9={"","."}),"",IF(ISNA(VLOOKUP(AQ9,[file.xls]sheet!$AP$1:$AP$3355,1,0)),"dif","dup")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup for multiple row data | Excel Worksheet Functions | |||
How to vlookup data | Excel Worksheet Functions | |||
vlookup with .csv data | Excel Worksheet Functions | |||
VLOOKUP and Add data | Excel Worksheet Functions | |||
vlookup when data is not all in same row | Excel Worksheet Functions |