Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large Formula Combination Trouble
I will create the scenario to better help explain.
On Tab 1 I have Column A and B On Tab 2 I have Column C and D I want to take the value from the cell in column A with in Tab 1 Find that text in Tab 2. If found then in Tab 2 column C then in column D insert the value from Tab 1 column B Is this possible? Could someone show me how? I have learned allot in Excel but this one is trumping me. Thank you for any help you may give. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large Formula Combination Trouble
One way:
Tab2, Column D: D1: =IF(ISNA(MATCH(C1, Tab2!A:A, FALSE)), "", VLOOKUP(C1, Tab2!A:B, 2, FALSE)) Note that worksheet functions can't insert values in other cells. In article , ihatetheredskins wrote: I will create the scenario to better help explain. On Tab 1 I have Column A and B On Tab 2 I have Column C and D I want to take the value from the cell in column A with in Tab 1 Find that text in Tab 2. If found then in Tab 2 column C then in column D insert the value from Tab 1 column B Is this possible? Could someone show me how? I have learned allot in Excel but this one is trumping me. Thank you for any help you may give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMBINATION FORMULA | Excel Discussion (Misc queries) | |||
Having Trouble with the RANK Function...Try LARGE or SMALL Functio | Excel Worksheet Functions | |||
Trouble opening large size Excel file 155Mb in Excel 2007 | Excel Discussion (Misc queries) | |||
Formula Combination | Excel Worksheet Functions | |||
Trouble with Filters on a large file | Excel Discussion (Misc queries) |