Hi,
I have a formula in one of my cells that is:
[=IF(D23="","",VLOOKUP(D23,Prices,IF(B23="Y",4,3)))]
The problem that I am having is that the formula sometimes pulls up the wrong data.
I used to have a formula that worked right, but it did not check to see if the "Y" was in a cell like I needed it too. That formula was this:
[=IF(D23="","",VLOOKUP(D23,Prices,3,))]
Why is the first formula not bring up the correct data? It is working like it is supposed to but it's pulling up the wrong data.
Any help would be greatly appreciated.
Thanks in advance!!!
Last edited by whatsmyname; 09-11-2009 at 04:12 PM.
It seems like it should work, but sometimes I've found that adding False at the end of VLOOKUP works.
So, try
modytrane=IF(D23="","",VLOOKUP(D23,Prices,IF(B23="Y",4,3,FALSE)))
sorry, that should be
modytrane=IF(D23="","",VLOOKUP(D23,Prices,IF(B23="Y",4,3),FALSE)))
Thank you so much.
That fixed me right up!!!
I appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks