Forum Discussion
help with functions
Do you have a sample of 20 POs with varied purchases that can be tested? Your sample file is sparse for testing, but here's a sample:
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.
