Auto populate with value

C

chris.howes

I am currently setting up an asset control sheet and in D2 i hav
multiple bundle type eg server, till, master till this then shows th
hardware included in each bundle eg pc, printer, chip & pin touc
screen etc

I am trying to auto populate the hardware columns so if it is a till i
enters a value of "1" in the relevant fields so i can then count eac
piece of hardware

I need a statement that will look at D2 and return a value of "1" i
the value = till or master till but not server

I have tried an if statement but it only gives 1 logical argument an
can not find any other way to get a value returne
 
K

kassie

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.
 
Top