Resolved · Urgent Priority · Version 2007
Wendy has attended:
Excel Introduction course
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?
For upcoming training course dates see: Pricing & availability
Hi, Can you please send me an example of your spreadsheet.
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.
Thu 16 Aug 2012: Automatically marked as resolved.