Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vlookup

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup

Vlookup

ResolvedVersion 2007

Wendy has attended:
Excel Introduction course

Vlookup

Can you please tell me if vlookup is able to read data from two columns rather than one? I cannot get the desired results I need as what I am trying to do is pull data from four columns (P-S) in one spreadsheet by reading the criteria held in both columns E and G.
How can I use a formula within vlookup to look at E and G data to pull the data from columns P-S that corresponds?

RE: vlookup

Hi, Can you please send me an example of your spreadsheet.

thanks
paul@stl-training.co.uk

RE: vlookup

Sorry it's too confidential. Not allowed to share it. Colleague in the office here I think has been able to nail it for me.
Thanks
Wendy

RE: vlookup

Great.

Thanks

Thu 16 Aug 2012: Automatically marked as resolved.

 

Training courses

98.7 % recommend us

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Please browse our web site to find out more about
excel training microsoft and other training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.