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.