HELP!!! excel Formula

[nganguyen303]

Hi all,

So I tried this formula yesterday and it worked fine but today, all the answers are blank even though some should be 1.

I have a column, DOH for a lot of locations. I want to populate on another cell, if DOH is greater or equal to 10, the cell will populate 1. On top of that, it only gives me a 1 for certain locations I choose (which I have created a separate sheet for a list of locations called B-stock Alloc.Locs)

Therefore, it will populate a blank if 1)DOH is less than 10 or 2) if DOH>= 10 but is not in a list of locations I have provided

The formula I used yesterday is:
=IFERROR(IF(Table1[[#This Row],[DOH1]]>=10,VLOOKUP(Table1[[#This Row],[Cricket_Location_Name]],'B-stock Alloc. Locs'!$A:$B,2,FALSE),""),"")

 

[henrik2h]

Doesn't your vlookup seem to have one argument to many? Or is it a typo in the text here? Something is most likely wrong with the vlookup, try and copy just that part to a new cell and carefully study your input.

 

[nganguyen303]

Doesn't your vlookup seem to have one argument to many? Or is it a typo in the text here? Something is most likely wrong with the vlookup, try and copy just that part to a new cell and carefully study your input.

I just checked and the formula I typed in was correct... It worked on yesterday's spreadsheet but not today. Is there another formula I can use?