Many VLOOKUP Columns - 1123 - Learn Excel from MrExcel

[Obosirow]

I have an acountin sheet dat vlooksup 4 diff columns on anoda sheet (h/i/j/k 6:h/i/j/k 1048576 respectively) in d same workbook. All 4 columns use a SN as criteria.Works ok. Problem is that when I input the SN, excel 2010 begins to calculate at the bottom bar and it could take days before it completes;it eats up my memory, slows my PC. Wat can I do to make it go faster yet lookin up all 4 data? I've even reduced d nos of cloumn cells 2 150000 yet it still take time to calculate.

Many thanks

[shonateen]

tooooooooooooo fast speech

[SatishCU]

bill, i have a query here if i want to have the results not in horizontal but in vertical then how to do this...

Plz help.

[SatishCU]

great