# Excel 2007 if and function

Closed
jb - Sep 29, 2010 at 07:57 AM
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
Related:

## 2 responses

Saman.tha Posts 1382 Registration date Monday May 25, 2009 Status Moderator Last seen September 14, 2015 33
Sep 29, 2010 at 08:48 AM
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.
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.