GOOGLE SHEETS: Vlookup Update on whole worksheet

[Afsheen]

Hi,

I need to update Vlookup formula range, In the worksheet I was matching keywords with column number 2, now I want to replicate the same sheet and want to match the values with column number 4.
Is there any option I can update formula in my whole worksheet in Google Spreadsheets.

Please Help

Here is the formula

=VLOOKUP(C17,Sheet2!$A$3:$B$7062,2,false)
Also if I need to update the Range i-e "7062" How would I do that

[Keebellah]

Place the complte range you want in the range section and the column you need, the column must always be inside the range columns

[Afsheen]

Vlookup formula is added in multiple columns

I need to manually update each time and drag towards the bottom. If there any bulk update option in workbook ?

[JohnTopley]

As per previous reply

change to all ...

=VLOOKUP(C17,Sheet2!$A$3:$E$7062,2,false)

and change required column as needed ..

If you need to MATCH with column 4 ie column D

=VLOOKUP(C17,Sheet2!$D$3:$E$7062,2,false)

or match with A but get data from column D

=VLOOKUP(C17,Sheet2!$A$3:$E$7062,4,false)