Any Excel gurus ??????????????????

[Barch]

Can an Excel guru please help?

I would like to set up a spreadsheet tracking registration numbers and their companies using IF THEN type formulas such as …

IF A1= abc THEN B1=mno

IF A1= def THEN B1=qrs

etc etc.

If possible I would like to have 12 registration numbers and 4 companies to track.

I am looking to get as much of the data automated because the users are not very computer savvy.

 

[Tin basher]

I've never excelled at anything, so sadly no help here from the goats long time resident IT Biff

 

[Oldstacker]

Can an Excel guru please help?

I would like to set up a spreadsheet tracking registration numbers and their companies using IF THEN type formulas such as …

IF A1= abc THEN B1=mno

IF A1= def THEN B1=qrs

etc etc.

If possible I would like to have 12 registration numbers and 4 companies to track.

I am looking to get as much of the data automated because the users are not very computer savvy.

Entirely possible, although I am not competent enough to explain it here and have to follow Excel help pages when I want to do it. The basic IF formula in Excel is

=IF(A1="ABC","def","ghi"),

where A1 is the cell being tested to see if it contains ABC,
def is the value that would appear in the cell containing the formula IF A1 = ABC and
ghi is the value that would appear in the cell if A1 does not contain ABC.

It is possible to replace the ghi in the formula with a further =IF clause to give 2 further possibilities. That process is called a Nested IF statement and can be repeated more than once (nesting within a nested statement). If you search Excel Help for Nested IF it is reasonably helpful.

 

[busby1971]

try Look up and pivot tables,

 

[Barch]

try Look up and pivot tables,

Cheers, I will give it a go.

 

[Barch]

Entirely possible, although I am not competent enough to explain it here and have to follow Excel help pages when I want to do it. The basic IF formula in Excel is

=IF(A1="ABC","def","ghi"),

where A1 is the cell being tested to see if it contains ABC,
def is the value that would appear in the cell containing the formula IF A1 = ABC and
ghi is the value that would appear in the cell if A1 does not contain ABC.

It is possible to replace the ghi in the formula with a further =IF clause to give 2 further possibilities. That process is called a Nested IF statement and can be repeated more than once (nesting within a nested statement). If you search Excel Help for Nested IF it is reasonably helpful.

Cheers, I will give it a go.

 

[PSFbeatch]

Can an Excel guru please help?

I would like to set up a spreadsheet tracking registration numbers and their companies using IF THEN type formulas such as …

IF A1= abc THEN B1=mno

IF A1= def THEN B1=qrs

etc etc.

If possible I would like to have 12 registration numbers and 4 companies to track.

I am looking to get as much of the data automated because the users are not very computer savvy.

3 options - you could have a nested if statement which would be quite long. You could use a lookup formula or you could use a drop down with indirect formula.

 

[Barch]

Thanks for the replies, it is now functional.

It was the son of Gem (RIP) that actually did the donkey work for me and got it up and running.