Using Maco to update Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the VLookup formula to pull data from another sheet. The column
to look up is A. I did not hard code the A reference. I copied the column
over and now the lookup column is B. How can I replace the value b with the
value A. I was able to use find/replace to change 24 to 25 but find/replace
is not able to change b to a. I am not very familiar with macros and tried
it on my own, to no avail.

Ex. VLOOKUP(B1419,'Forecast View By QTR'!$A$271:$AA$1829,25,FALSE)

Any help greatly appreciated.
 
Hi

Find/Replace should work.
Try Find (B
Replace (A
otherwise it will also replace the B in "By".
 
Back
Top