Use VLOOKUP function to create dynamic charts – Excel Tips and Tricks

Use VLOOKUP function to create dynamic charts – Excel Tips and Tricks

Use VLOOKUP function to create dynamic charts.

Here are the steps featured in my video.

Dynamic Chart Using VLOOKUP
1) Highlight the row like this
2) =VLOOKUP($B$5,$B$18:$F$33,COLUMN(B17),0)
3) Ctrl + Enter

Drawing Chart
1) Select row
2) Alt + F1
3) Resize and reposition

The formula VLOOKUP($B$5,$B$18:$F$33,COLUMN(B17),0) searches for the value in B5 in the range $B$18:$F$33. Using COLUMN(B17) allows for the selection of the specific column to retrieve from the range. In this case, COLUMN(B17) results in 2 (the column position of B), so VLOOKUP will fetch the value from the second column of $B$18:$F$33. If the value in B5 is not a perfect match, the formula will generate an error as indicated by the 0 at the end.

#tips #excel #shorts #fyp

Close Menu