How to Lookup Values Using Multiple Columns in Excel

[PleaseGoAway1000]

crap

[kym9932]

I gave this a try but it will only do the look-up a couple of times and then it errors out

Any suggestions

[DannyRocksExcels]

@kym9932

To give you an answer, I really need to see a sample of your data. Feel free to email me a sample so that I can work on this to help you find a solution.

Danny Rocks

The Company Rocks

[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

[TheCake86]

Thanks very much Danny that helped alot, cheers.

[DannyRocksExcels]

@TheCake86

My pleasure. I am delighted that I could help you to learn more about Excel. Thanks for writing to tell me this.

Danny Rocks

The Company Rocks

[2009jaxs]

Hay DannyRocks, You have helped me in the past, I have 4 issues with my spread sheet. I have been working on this for many, many hours and about to give up. I have searched all over the web to teach myself, but I am stuck.

Need Help. 3 items are VBA and have completed about 85% of the goal with 2 of the VBA.

The other VBA I need to start from scratch.

Last last issue is date & time with cell activation.

Is there anyway you can help outside of the You_Tube forum?

Thanks

[DannyRocksExcels]

@2009jaxs

Hi - I am sorry that I missed your message originally. I might be able to help you. Go to the website for The Company Rocks and send me a message there.

Danny Rocks

The Company Rocks