Posted to microsoft.public.excel.misc

nastech

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup question	Greegan	Excel Worksheet Functions	3	December 20th 05 04:00 AM
VLOOKUP() Question... i hope	Adam Kroger	Excel Discussion (Misc queries)	2	November 29th 05 10:22 PM
Vlookup question please	Bob Newman	Excel Worksheet Functions	3	March 17th 05 02:17 PM
vlookup question please	Bob Newman	Excel Worksheet Functions	1	March 17th 05 06:25 AM
Vlookup against multiple columns/worksheets question	JCarter	Excel Discussion (Misc queries)	8	March 9th 05 04:59 PM

All times are GMT +1. The time now is 08:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us