Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare cell value
In an excel sheet, say we have some set values in A2 to A50 and B2 to B50 and
C2 to C29. Now we need to compare say A30 onwards to cell values A2 to A29 and B30 onwards to B2 to B29 and if both values found then the row in which both value found, the value in column C will be the value in the C column of cells C30 onwards. Hope this example explains the problem clearly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare data - one cell to multiple cells | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |