I need help with a vlookup formula but I'm unclear if I need to use an IF statement or Vlookup
Example of what I'm try to do:
If I lookup File A and lookup File B and they both equal then I want to pull data from File B – U2 into File A P2, if not then I want 0
File A
A2 J2 P2
201010 611100
File B
A2 J2 U2
201010 611100 178640.00
Below is the Formula I was trying to use with no luck.
=VLOOKUP(A2,'[FY 11-12 Base Budget (Final).xlsx]Summary'!$A$1:$V$1835,21,TRUE) and VLOOKUP(J2,'[FY 11-12 Base Budget (Final).xlsx]Summary'!$J$1:$U$1835,21,TRUE)
Bookmarks