If VLookup

[mjoyce1994]

I'll try to explain what I'm doing then add a picture for context.

On another sheet (we'll call sheet 2) I have added two values together to get a sum. Those values are in column K. In K those values are either marked as "-" or a number.

On sheet 1, I am trying to do a vlookup of that value. IF the value is populated in K i want it to appear in my vlookup, if not I want the value in column F (on sheet 1, where I'm doing my vlookup) instead

 

[Special-K99]

No picture visible.

FYI

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Here's the first question...

What happens if the same value appears more than once in column K?
A VLOOKUP will only find the first occurrence of the value.