View Single Post
  #1   Report Post  
jlmam
 
Posts: n/a
Default 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!