Results 1 to 16 of 16

Excel 2007 : IF function

Threaded View

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    IF function

    So what im trying to do is:

    i have 5 rows on sheet2 and 5 rows in sheet1 and what im trying to do is make condisions like this:

    If velues in rows B2,C2,D2,E2 on sheet2 are the same as the values in rows somewhere in the B,C,D,E (has to be the same row number like(B5,C5,D5,E5) on sheet1 then copy or vlookup or match value from A(from say A5) from sheet1 to row on to sheet2 (like B1).

    I Tryed using IF function if,if,if,if,if but all i got was FALSE

    Please I need this. Then i'll be quiet for a while
    Last edited by stojko89; 05-29-2009 at 01:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1