Excel 2007 if and function [Closed]

- - Latest reply:  jb - Sep 30, 2010 at 03:38 AM
Hello,

It sound simple but i can't figure it out..


I have 3 cels and i wanne have 1 value

example

A B C
33572 SNAKE 365
33572 SUGGER 366
33572 SALT 367

i want to combine A B to result C

how can i do this?

thanks
See more 

2 replies

Posts
1391
Registration date
Monday May 25, 2009
Status
Moderator
Last seen
September 14, 2015
27
0
Thank you
I hope I didn't get it wrong. Juste type into C1: =A1+B1 and tap enter. Afterwards you can copy it (just drag) to all the other cells in the C column. The formula will automatically adapt to the number of the row like =A2+B2 or =A3+B3 ....

Is not like that

sheet 1

A- B- C-
621- 308043- EIG
621- 308044- OPBEH
621- 308045- GEBR
622- 308046-
622- 308047-
622- 308048-
623-308049-
623-308050-
623-308051-


Sheet 2
A B
621 ?
622 ?
623 ?


on the second sheet I have the number 621

need de number from B combine if A combine with C on sheet 1

and have number 621 on collum A on the second sheet.

so how can i have Number on kolom B on the second sheet IF i only want it from EIG?

if i have more than 1000 numbers under each other.
on C the 3 words is comming again Eig OpBEH and GEBR.
0
Thank you
Is not like that

sheet 1

A- B- C-
621- 308043- EIG
621- 308044- OPBEH
621- 308045- GEBR
622- 308046- EIG
622- 308047- OPBEH
622- 308048- GEBR
623-308049- EIG
623-308050- GEBR
623-308051- OPBEH


Sheet 2
A B
621 ?
622 ?
623 ?


on the second sheet I have the number 621

need de number from B combine if A combine with C on sheet 1

and have number 621 on collum A on the second sheet.

so how can i have Number on kolom B on the second sheet IF i only want it from EIG?

if i have more than 1000 numbers under each other.