• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    vlookup 2nd instance

    Due to having an old brain I had to use a combination of all three answers for it to finally sink in. =IFERROR(INDEX('vm partition Data'!D1:D215,SMALL(IF(Working!$D$8='vm partition Data'!$A$1:$A$215,ROW('vm partition Data'!A1:A215)),COLUMN(B$1))), "")/1024 Above was the final formula for...
  2. D

    vlookup 2nd instance

    I am writing a documentation tool for vmware and have the following in worksheet "vm partition Data" Server Name, Disk, Capacity MB, Bob, Hard Disk 1, 2048 Bob, Hard Disk 2, 4096 On the first worksheet I am using the vlookup function as follows =VLOOKUP(Working!$D$8,'vm partition...
Back
Top