Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
Vlookup query | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |