Hi,
I am trying to look at 2 fields in one sheet and have a vlookup bring over 2 other fields in another sheet based on the first criteria but its not returning the correct amount based of the first criteria. Heres an example,
IF(AND(B6="Host",D6="WTK-HR"),IF(D6="WTK-HR",VLOOKUP(D6,EECnt,3,FALSE),IF(B6="Host",VLOOKUP(AQ6,WatchList,5,FALSE),"NA")))
So I want to vlookup in the Watchlist Tab, that if its WTK-HR AND what is in AQ6 cell ie (500-1000 employees), then bring me back the price for the correct employee count. The answer that its returning is the first WTK-HR it sees in the Watchlist which is for the wrong employee count. I know I need a correlation between WTK-HR and the employee count but I dont know how to make that happen.
Thanks in advance!
A
Bookmarks