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!

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!

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!