#1   Report Post  
sydolly
 
Posts: n/a
Default Vlookup or If query


Hi,

Here is my data and formula
A B C
0:10:00 0:32:00 =if(b1=a1:a3,Break,N/A)
0:11:00 0:10:00
0:12:00 1:07:00

but the data from B column is formulas and not a typed value.

any suggestions


--
sydolly
------------------------------------------------------------------------
sydolly's Profile: http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466425

  #2   Report Post  
duane
 
Posts: n/a
Default


It sounds like you are trying to see if entry in column b exists
anywhere in column a. If so

=if(not(iserror(match(b1,$a$1:$a$3,0))),"Break","N/A")


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=466425

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
MS Query not installed for New Database Query Malcolm Walker Excel Discussion (Misc queries) 0 August 2nd 05 10:58 PM
"Query cannot be edited by the Query Wizard" PancakeBatter Excel Discussion (Misc queries) 0 April 25th 05 05:59 PM
Non-sequential VLOOKUP function -OR- sequential sort of web query Eric S Excel Worksheet Functions 1 February 28th 05 08:50 PM
Vlookup query gb_S49 Excel Worksheet Functions 3 January 22nd 05 01:25 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 08:54 PM


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"