VLookup using a row number

[Colmans]

I have a report which highlights data matches in two different spreadsheets where the output shows the row number of the main source data.

I now want to add a value in my report which, for example will report the third column of the selected line in the source data which contains an e-mail address. How do I do tthat using the row number?

Thanks in advance for your feedback.

 

[Joe4]

If you know the column and row number, you can build the cell reference using the INDIRECT function.
See here: Excel INDIRECT function - basic uses and formula examples