| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF ISNA Help
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF(ISNA.... | Excel Discussion (Misc queries) | |||
| ISNA Help | Excel Worksheet Functions | |||
| ISNA help | Excel Worksheet Functions | |||
| Using ISNA with OR | Excel Worksheet Functions | |||
| ISNA | Excel Worksheet Functions | |||
![Act Guy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
