Posted to microsoft.public.excel.misc

nastech

Posts: n/a

VLOOKUP Question..

ahhh.. had that happen before, similar answer to (what do you call it?) a
double negative? guesse I call it a double-whamy twice over.. thanks !!

"flummi" wrote:

Sorry, withouth the equel sign in the middle.

=if(isna(VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)),"",VLOOKUP(V1Â*24,[file.xls]sheet!$A$1:$B$3355,2,FALSE))

Hans

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us