View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default VLOOKUP Question..

Hi, I am trying to mirror the info from a different workbook, into work
column of new book. need to get data into new sheet. so far have equation
that shows for duplicate records, but am trying to get info from different
column in old book:

have:
=IF(ISNA(VLOOKUP(V124,[file.xls]a!$V$2:$V$3355,1,0)),"dif","")

need to have data from column a in the file.xls thanks.