Say you have your database in a range called Customers, with Surnames in Col
A, Account Nrs in Col B and Sub Account numbers in col C, and you enter the
customer name in say B10 on a form. Then in C10 enter
=VLOOKUP(B10,Customers,2,FALSE)&VLOOKUP(B10,Custom ers,3,FALSE).

If you want a space between the 2 numbers, use
=VLOOKUP(B10,Customers,2,FALSE)&" "&VLOOKUP(B10,Customers,3,FALSE)

"Jaleel" wrote:

Can anybody help me with a formula to lookup 2 values simultaneously like
Account No. and Sub Account No.?

Thanks in advance.

Jaleel