+ Reply to Thread
Results 1 to 2 of 2

Vlookup confusion

  1. #1
    Forum Contributor
    Join Date
    01-28-2007
    MS-Off Ver
    2019
    Posts
    205

    Vlookup confusion

    Can anyoine help me, i cant work out why the vlookup in column C (cell c3) isnt pulling the correct corresponding cost from the "Const Material Costs" ?
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,054

    Re: Vlookup confusion

    You need to put:

    =VLOOKUP(A3,'Const Material Costs'!$A$3:$B$250,2, FALSE)
    Never use Merged Cells in Excel

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1