Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If condition
I have three columns in a separate worksheet suppose worksheet "A". I want to
compare a cell value in another worksheet "B" with the first column of the worksheet "A" and if a perfect match is found i want to perform calculation based on the rows in which the match was found. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If condition
Try something similar to:
=if(isna(vlookup()),0,vlookup()*2) "Lucky_Tiaz" wrote: I have three columns in a separate worksheet suppose worksheet "A". I want to compare a cell value in another worksheet "B" with the first column of the worksheet "A" and if a perfect match is found i want to perform calculation based on the rows in which the match was found. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If condition
How to do this depends on the calculation you want to do. If it is just
counting or adding you may be able to use COUNTIF or SUMIF functions to do this (look in help for details). "Lucky_Tiaz" wrote: I have three columns in a separate worksheet suppose worksheet "A". I want to compare a cell value in another worksheet "B" with the first column of the worksheet "A" and if a perfect match is found i want to perform calculation based on the rows in which the match was found. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAX with condition | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
using AND and OR as an if then condition | Excel Programming |