Forum Discussion

MDV005's avatar
MDV005
Copper Contributor
Apr 23, 2020

Excel beginner - VLOOKUP

Hi, Can anyone see what is wrong with this formula which requires the value in G6, to be search in the previous sheet  Cells B17-B20 and bring across the cell contents in the next column C17-C20?   ...
Formulas and Functions
MDV005's avatar
MDV005
Copper Contributor
Apr 23, 2020
Sorry - this didn't seem to help
Patrick2788's avatar
Patrick2788
Silver Contributor
Apr 23, 2020

MDV005 

Were you looking to do more with the VLOOKUP? Abiola1 's solution looks good.

Resources