I have what probably should be in one many-rowed table broken into three
separate tables side by side just so I can see them more easily.


......a.................b........c.......d........ ....e........f......g.............h
1..Phillip.........90..............Andy......10... .........Steward..6
2..Rebecca.....24..............Angela...10........ ....Greg.......5
3..Tracy..........20..............Sam.......10
4..Keith...........20


I want to enter a name and have the number associated with that name
returned. That would be easy with the vlookup if it were all in one
table_array {vlookup("tracy",a1:b4,2)} but how do I do it with the data
broken up? Is there a way to keep the visual ease like I have it and
reference multiple ranges?