Excelguru Help Site - hochoaivandot

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (9)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (12)

Excel - Power Query (3)

Excel - PowerPivot (7)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (49)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (1)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

Power BI (3)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (10)

Word - VBA Programming (8)

hochoaivandot

There is no available content written by hochoaivandot

Recent Forum Posts

Not able to figure out how to fetch a column value present in a different excel sheet

Here you go:

=LOOKUP(2,1/((Sheet2!$A$2:$A$11=A2)*(Sheet2!$C$2:$C$12=4)),Sheet2!$B$2:$B$12)...
AliGW Yesterday, 02:43 PM

Not able to figure out how to fetch a column value present in a different excel sheet

Hi Ali,
Thank you for your response.
Uploaded.....
ajyexcel Yesterday, 02:07 PM

Specification Comparison Table from Different Worksheets

Well, you've made this much harder to test by using the RAND() formula and not then copying and pasting values, and I don't have time to fix that on top...
AliGW Yesterday, 09:07 AM

Specification Comparison Table from Different Worksheets

Aaarrrggghhhh!!!!

I have just noticed another bloody merged cell - ROLL. Going to have to re-write again. NOW I'm getting annoyed. ...
AliGW Yesterday, 08:31 AM

Specification Comparison Table from Different Worksheets

OK - the thing is, when you ask for help, you really need to try to make sure that the data you provide as a sample truly reflects the data you are working...
AliGW Yesterday, 08:20 AM

All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.

Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.

Gravatar by 1e2.it