Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populate with value
I am currently setting up an asset control sheet and in D2 i have multiple bundle type eg server, till, master till this then shows the hardware included in each bundle eg pc, printer, chip & pin touch screen etc I am trying to auto populate the hardware columns so if it is a till it enters a value of "1" in the relevant fields so i can then count each piece of hardware I need a statement that will look at D2 and return a value of "1" if the value = till or master till but not server I have tried an if statement but it only gives 1 logical argument and can not find any other way to get a value returned -- chris.howes ------------------------------------------------------------------------ chris.howes's Profile: http://www.excelforum.com/member.php...fo&userid=5660 View this thread: http://www.excelforum.com/showthread...hreadid=550283 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populate with value
I do not understand your statement that If only gives 1 logical argument, but:
I would suggest you create a database of items, , say in Col A on another worksheet, and with the value you want returned in Col B. Give this range a name, eg Data, then use a VLOOKUP formula to extract the correct value for each item. Say you have "TILL" in A1 on your asset control sheet, then in B1 enter =IFA1="","",VLOOKUP(A1,Data,2,FALSE)). If you need a value of say 6 for server, then that will be correctly extracted as being 6, and so on. "chris.howes" wrote: I am currently setting up an asset control sheet and in D2 i have multiple bundle type eg server, till, master till this then shows the hardware included in each bundle eg pc, printer, chip & pin touch screen etc I am trying to auto populate the hardware columns so if it is a till it enters a value of "1" in the relevant fields so i can then count each piece of hardware I need a statement that will look at D2 and return a value of "1" if the value = till or master till but not server I have tried an if statement but it only gives 1 logical argument and can not find any other way to get a value returned -- chris.howes ------------------------------------------------------------------------ chris.howes's Profile: http://www.excelforum.com/member.php...fo&userid=5660 View this thread: http://www.excelforum.com/showthread...hreadid=550283 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate dates | Excel Discussion (Misc queries) | |||
How to insert auto populate calendar icon? | Excel Discussion (Misc queries) | |||
Auto Populate Time | Excel Discussion (Misc queries) | |||
Function for Auto Populate | Excel Worksheet Functions | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) |