Fetch a value from a different sheet using Index Match or Vlookup

Thomas Preston · 07/03/24

I have 2 Sheets, both of which share 2 columns - an Events colum, and a Budget column.

In Sheet A, the Budget column is empty. In Sheet B that column is filled.

What I want to achieve, is to fill the empty Budget column in Sheet A, if the value of the Events column is the same in both Sheets.

I think this is very straight forward, an Index Match perhaps but I'm not sure exactly how to write the formula.

Paul Newcome · 07/03/24

It would look something along the lines of

=INDEX({Source Sheet Budget Column}, MATCH([Event Column]@row, [Source Sheet Event Column}, 0))

Thomas Preston · 07/03/24

Spot on! Many thanks

Paul Newcome · 07/03/24

Happy to help. 👍️

Answers