=IF(VLOOKUP(T15,'Ex Clear'!$S$2:$S$2001,1,FALSE)=Govi!T15,IF(VLOOKUP(Govi!S15,'Ex Clear'!$U$2:$U$2001,1,FALSE)=Govi!S15,IF(VLOOKUP(Govi!B15,'Ex Clear'!$W$2:$W$2001,1,FALSE)=Govi!B15,IF(VLOOKUP(Govi!A15,'Ex Clear'!$X$2:$X$2001,1,FALSE)=Govi!A15,VLOOKUP(T15,'Ex Clear'!$S$2:$V$2001,4,FALSE),0))))
The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one...
This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the formula...meaning it doesn't matter if the numbers match up, it just brings the first value. How can I get it to bring the correct one if everything matches?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o><o></o>
The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one...
This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the formula...meaning it doesn't matter if the numbers match up, it just brings the first value. How can I get it to bring the correct one if everything matches?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o></o>
