I have a VBA search function that uses 5 criteria, one of the results
is, that it tells me what row in the sheet the item is located.

If I now the row the item is on, how can I use this row number to find
the value in a column?