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