ExcelBanter - View Single Post

Act Guy[_2_]

Thanks David!

"David Biddulph" wrote:

You may wish to use the INDIRECT function. Details in Excel help.
--
David Biddulph

"Act Guy" <Act wrote in message
...
I am creating a checkbook for work. I need help with determining how to
type
a number in one cell (i.e. '7245) and get it to produce the name of the
account that belongs to 7245. This is what i have so far. I am just not
sure what to do with the part that says 'account number'. Do i create a
seprate file with these names? or do i put them in the table somewhere?
Please help! Thanks!

IF(ISNA(VLOOKUP(A7,'Account
Numbers'!A$2:B$327,2,FALSE)&"-"&VLOOKUP(B7,'Account
Numbers'!C$2:D$1443,2,FALSE))," ",VLOOKUP(A7,'Account
Numbers'!A$2:B$327,2,FALSE)&"-"&VLOOKUP(B7,'Account
Numbers'!C$2:D$1443,2,FALSE))