98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Intermediate Course
Intermediate Course
Resolved · Low Priority · Version 2003
Wed 23 Apr 2008, 17:00Delegate Penny said...
Penny has attended:
Excel Intermediate course
PowerPoint Introduction course
Intermediate Course
can I do a nested v looker function
Thu 24 Apr 2008, 09:32
Edited on Thu 24 Apr 2008, 09:34Trainer Pete said...
RE: Intermediate Course
Hi Penny, thank you for your post, in answer to your question, yes you can, say for example you wished to use the vlookup function across multiple tables you could combine Vlookup with IF and then enter something like this:
=IF(A1=1,VLOOKUP(B1,TABLE1,2,FALSE),IF(A1=2,VLOOKUP(B1,TABLE2,2,FALSE),IF(A1=3,VLOOKUP(B1,TABLE3,3,FALSE),IFA1=4,VLOOKUP(B1,TABLE4,2,FALSE),IF(A1=5,VLOOKUP(B1,TABLE5,2,FALSE,"")))))
So this has checked 5 different tables for values 1 - 5 and returned what ever the value is in column 2 from the corresponding table.
I hope that has made sense, and helped, if so please click the resolved link, best regards Pete.
Pete Emmerson - Microsoft Office Specialist Master Instructor.
Training information:
See also:
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide data in Excel WorksheetsLet's say you have some data in cell 'C5' you would like to hide from the casual viewer. |
