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

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