Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function to look at two cells and return a third
I'm hoping someone can help me. This seems like a simple task but I'm at a
loss. Here is a current working formula, but I need to look at TWO cells instead of just one: =VLOOKUP(A2,GLextract.xls!list,2,0) I have two worksheets, one contains a table and one contains the data where the formula will reside. For example: Table: A2 B2 C2 26062 5010 2502000 Data: A2 B2 C2 D2 26062 5010 Sales - Industrial (Formula) I want the formula to look at cells A2 and B2 and return the value in C2. I tried: =VLOOKUP(A2&B2,GLextract.xls!list,2,0) I also tried an IF function: =IF(A2&B2=Table!A2&B2,C2,"ERROR") Any help would be appreciated. As you can tell, I'm a novice with functions! |
#2
|
|||
|
|||
I would set up a hidden column which pre-concatenates the two entries on the
lookup sheet and then use your first attempt. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "jlmam" wrote in message ... I'm hoping someone can help me. This seems like a simple task but I'm at a loss. Here is a current working formula, but I need to look at TWO cells instead of just one: =VLOOKUP(A2,GLextract.xls!list,2,0) I have two worksheets, one contains a table and one contains the data where the formula will reside. For example: Table: A2 B2 C2 26062 5010 2502000 Data: A2 B2 C2 D2 26062 5010 Sales - Industrial (Formula) I want the formula to look at cells A2 and B2 and return the value in C2. I tried: =VLOOKUP(A2&B2,GLextract.xls!list,2,0) I also tried an IF function: =IF(A2&B2=Table!A2&B2,C2,"ERROR") Any help would be appreciated. As you can tell, I'm a novice with functions! |
#3
|
|||
|
|||
I need to make an addition to one of my sentences:
I want the formula to look at cells A2 and B2 IN WORKSHEET 'TABLE' and return the value in C2 FROM WORKSHEET 'TABLE'. Sorry about the confusion "jlmam" wrote: I'm hoping someone can help me. This seems like a simple task but I'm at a loss. Here is a current working formula, but I need to look at TWO cells instead of just one: =VLOOKUP(A2,GLextract.xls!list,2,0) I have two worksheets, one contains a table and one contains the data where the formula will reside. For example: Table: A2 B2 C2 26062 5010 2502000 Data: A2 B2 C2 D2 26062 5010 Sales - Industrial (Formula) I want the formula to look at cells A2 and B2 and return the value in C2. I tried: =VLOOKUP(A2&B2,GLextract.xls!list,2,0) I also tried an IF function: =IF(A2&B2=Table!A2&B2,C2,"ERROR") Any help would be appreciated. As you can tell, I'm a novice with functions! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions | |||
Return non-zero cells in column | Excel Worksheet Functions | |||
Adding multiple cells, return specific values | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions |