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