Forum Discussion
help with functions
I need to keep track of running balance for purchase orders. My spreadsheet contains columns for: Vendor Purchase Order # Original AMT PO Funding CURRENT BALANCE PURCHASE DATE Time Auth...
I don't have that information and will have to create fake data to test.
I've also discovered a glitch in my vlookup function. If I use $ to specify then the next row is not correct. I.E., =VLOOKUP(A4,REFERENCE!$A$32:$C$32,2,FALSE) and =VLOOKUP(A4,REFERENCE!$A$32:$C$32,3,FALSE)
How do I use that formula to specifically identify the value in column A? In the Reference worksheet "Sample Entry" is in row 32, however, "ABC Supply" is on row 3 of column A. Which means that I can't just copy the VLOOKUP down to the next row in columns B and C because that will on reference $A$32:$C:$32. It needs to reference the vendor by name and specific row for that vendor in order for the data to be correct. I thought I had the vlookup ready to run.
