I have used Vlookup to do simple searches, but this one is proving to be more
complex.

In Column A we have names

In Column E we have names
In Column F we have a numerical value

Column H we have names
Column I we have numerical value

I need a function that will search Column E or H, and if E or H match the
name in column A, return value F or I(respectively).

So I am guessing id probably use nested vlookups, but was having trouble
getting it to work.