I would set up Fund A, Fund B...etc in say 10 blocks
each containing two columns for clients and account numbers

loop through column A
for i = startrow to lastrow
select case range("A" & i)
"Fund A" : range("C" & i) = vlookup(range("B" & i), block of Fund A, 2)
"Fund B" : etc
etc
end select
next i


"George" wrote:

I am trying to write a macro which checks the data in cell A and B in a
worksheet then outputs in col c.
e.g
If Cell A1 = "Fund A" and ' check Fund here
Cell B1 = "Client Name" then ' check list of clients here
Cell C1 = "account number" ' output clients a/c no. here from list
end

This statement needs to run through all of Col A and B and check 10
different Funds and 20 client names. to produce given account number