Forum Discussion
VLOOKUP
| =VLOOKUP(A2,Sheet2!$A$2:$C$1176,2,FALSE |
I am looking up an account number (A2) on "BatchPatientStatement" in sheet 2 and asking it to return a value from column 2 from sheet 2 if the account # is found. Where am I making the mistake? It's not showing an error, it's returning the formula only. Attached is a sample report.
you column is formatted as TEXT. highlight column G and change the formatting to General. Then enter the formula (I clicked in the cell and deleted the "=" and retyped the = and hit enter, but really you just need to click in the cell and hit enter) and it worked 🙂
