|re: "Unfortunately, I can not post an example of my data due to its confidential nature. "|
It's not about the data itself, it's about your formulas, referenced cells, etc.
You could use cats, dogs and colors as your data. The formulas will either work based on the layout or they won't.
This is what your formula tells me that you are trying to do, because this is the only way the formula will work:
- You have 2 sheets.
- One is named Tally
- The other is named..I don't know...let's call it Sheet1
- Somewhere on Sheet1 you have this formula:
=IF(B11=Tally!$G$35,VLOOKUP(BA11,Tally!$F34:$L$56, 5, 0),0)
- In Tally!$G$35 you have some data. I'll use CowPie.
- In Sheet1!BA11, you have some data. I'll use Mucus.
- In Sheet1!B11, you have some data.
- If the data in Sheet1!B11 happens to be CowPie, you want VLOOKUP to find Mucus in Tally!$F$34:$F$56 and return the data in Tally!Column J, in the same row in which Mucus was found.
- If the data in Sheet1!B11 is not CowPie, you want the formula to return 0.
I set up a workbook as described above and here's what happens:
- If the data in Sheet1!B11 is not CowPie, the formula returns 0, as expected.
- If the value in Sheet1!B11 is CowPie and Mucus is found in Tally!$F$34:$F$56, the formula returns the value in TALLY!Column J, in the same row in which Mucus was found, as expected.
- If the value in Sheet1!B11 is CowPie and but Mucus is not found in Tally!$F$34:$F$56, the formula returns #N/A, as expected.
It works exactly as I would expect it to work.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.