Posted to microsoft.public.excel.misc
|
|
Vlookup for more than one cell
yes..Biff is correct!
-via135
Sweetetc Wrote:
Even if I put the look up value in c1 Sheet 2 as LIAB 1103
Sheet #1 houses them in 2 different cells. How does this lookup work.
--
Thanks
ETC
"via135" wrote:
hi!
why don't you try
=index(sheet2!A1:A10,match(c1,sheet2!B1:B10,0))
where c1 houses your lookup value?
-via135
Sweetetc Wrote:
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
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=564006
--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=564006
|