Vlookup for more than one cell
Let me give it a try
Thanks
ETC
"Biff" wrote:
I was hoping that I could do look up that says vlookup.
Vlookup won't work in this case.
An alternative to the array formula**:
=SUMPRODUCT(--(Sheet1!A$1:A$100="LIAB"),--(Sheet1!B$1:B$100=1103),Sheet1!C$1:C$100)
** This will only return the correct result if there is only one instance of
LIAB 1003.
Biff
"Sweetetc" wrote in message
...
Worksheet #1 has a lot of data Within the data we have the Word "LIAB"
in
column A and # in Column B See Below
A B C
Aug-05 1103 44,023.151
Jul-05 1103 42,684.574
LIAB 1103 340,573.884
AGED 1103 1,235,569.497
TOTALS 1103 1,576,143.381
Aug-05 1265 365.497
Jul-05 1265 7,012.625
LIAB 1265 64,477.315
AGED 1265 174,469.632
TOTALS 1265 238,946.947
My new spreadsheet #@ has just numbers.
A B
1103
1105
1106
How do I do a VLOOK UP to say: look for the numberA1from Sheet #2 in
Sheet
#1 and if it has the word LIAB in Column A then take the corresponding
cell
value in sheet #1 column C and put it into column B of Sheet #2
--
Thanks
ETC
|