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! |
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 |