VLOOKUP Copy & Paste
Greetings!
I have a document with one tab for each month and a final tab called "Acronyms." I have created a VLOOKUP which uses my input from column A (Product Number) in July, for instance, and returns a value to column B of July from column B in Acronyms (column A is also Product Number in this tab). The formula works perfectly.
VLOOKUP A19 , Acronyms::A2:B306, 2 , exact match
When I try to copy and paste the formula to down column B in July, however, the A2 becomes A3, etc.
VLOOKUP A19 , Acronyms::A3:B306, 2 , exact match
How can I get the initial formula to populate identically in each row?
Thanks and Blessings!
Tim
Earlier Mac models