VLOOKUP referncing the diagonal cell instead of the horizontal

A picture is generally pretty useless for diagnostics.

However, for an EXACT match, the last parameter should be FALSE.

If that doesn't fix it, please post a sample workbook.


Regards, TMS

You get better help if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Pictures are difficult to interpret the entire situation.

Originally Posted by TMShucks

A picture is generally pretty useless for diagnostics.

Seems to have worked for getting the conversation started.

Originally Posted by TMShucks

However, for an EXACT match, the last parameter should be FALSE.

I tried "false" but it returns #value.

Originally Posted by TMShucks

If that doesn't fix it, please post a sample workbook.


Regards, TMS

I have attached the workbook. Don't make fun of me, it's simple.

Ok. Try this. Change c3 to =ROUND(IF(B3-$B$2,$B$2-B3,0),2)

Change D3 to =VLOOKUP(C3,Reference!$B$1:$C$112,2,FALSE)

Sometimes, excel will add small decimals that are insignificant until you try to do comparisons. This is a technical flaw that has been discussed in many forums ad nauseum. It good to know and if you encounter unusual circumstances use the round feature.

Alan

Originally Posted by alansidman

Ok. Try this. Change c3 to =ROUND(IF(B3-$B$2,$B$2-B3,0),2)

Change D3 to =VLOOKUP(C3,Reference!$B$1:$C$112,2,FALSE)

Sometimes, excel will add small decimals that are insignificant until you try to do comparisons. This is a technical flaw that has been discussed in many forums ad nauseum. It good to know and if you encounter unusual circumstances use the round feature.

Alan

Something worked!

It's not "feelings" about them, it's frustration. You may know what it is you are trying to show us but it may not always be obvious to us. And there's no way of investigating or testing.

As for starting the conversation going, yes, it has, hasn't it? Three people asking you for a sample workbook and one tentative, untested suggestion ... which didn't work with your data. Sometimes I think I'm starting a conversation with my wife ... but sometimes it ends up being a row

Regards, TMS

Note that Alan's cool and calm replies were only possible once you had posted the workbook

Please Login or Register  to view this content.

That is not a nice respond to a member who was willing to help you.

You probably forget that you are asking a favour of the forummembers to help YOU with YOUR problem.

We are all volunteers, which will help other members on our "own conditions".

One of these conditions can be, asking for a usefull file, so we can test the solution we give.

Advicë: if you want to be helped in the future, don't be unpolite.

Just complained and whined....

I seem to recall that mine was the first response. Also, that the answer to the VLOOKUP part actually included the last parameter set to FALSE. It would not have been obvious to Alan, or anyone else, why it didn't work without the sample workbook which Alan, oeldere and I all requested.

Encouraging you to provide adequate information so that the volunteers in the forum can effectively respond to your problem can hardly be considered whining. I guess you don't cope well with constructive feedback.

Anyway, enough of this happy banter. I wish you well with your spreadsheet development and trust that we will see you back here soon.