Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula, NEED HELP!
I have two worksheets in one workbook. Both contain tables, one condenses
data from the other. I am needing to pull specific data from a column as result of data in two other columns with the end result in the second worksheet. Normally I would use the VLookup; however I have two ranges and this is not possible. So far this is the formula I have come up with, yet I have not be able to make it work. =IF('Report Data'!F7:F65536=1),('Report Data'!R7:R65536=QL), I1:I65536 PLEASE HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |