+ Reply to Thread
Results 1 to 2 of 2

Cross-reference formula help please

  1. 04-13-2013, 11:43 PM #1
    elite-fusion
    elite-fusion is offline
    Forum Contributor
    Join Date
    09-02-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    103

    Cross-reference formula help please

    Hey guys, just wondering if someone might be able to help me out....

    I have a formula which I use to compare two sheets, and if something matches, then it inserts a value from a different cell along that row. Here's an example....

    =IF(H1=H1,IFERROR(INDEX(Data!B:B,MATCH(H1,Data!D:D,0),1),""),"")

    This formula works great, but I feel like its a bit too complex. Since I am not good with excel formulas, I figured I would ask the community. Only reason why I want/need to simplify this is because google drive/docs does not calculate very fast and most of the time just doesn't do it at all because I have it running for about 1000 rows.

    I think there is a VLOOKUP way, but I am not sure....please advise
    Reply With QuoteRegister To Reply
  2. 04-13-2013, 11:58 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Cross-reference formula help please

    Well....the if H1=H1 is redundant, a cell will always equal itself...other than that, can't really tell if there is any easier way, I have nothing to base an opinion on ..

    EDIT-
    Actually..the column rages could be limited...say B$1:B$500000/D$1:D$500000 (as an example), for whole column ranges, it does 1 million plus comparisons, limit it to a reasonable size (ie- your data extends down to row 150000 (and maybe is growing), make the range 200000 or 300000) to reduce calculation times
    Last edited by dredwolf; 04-14-2013 at 12:06 AM.
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1