I need to find a cell value in the column in the sheet "FEDEX" that maches
entered value on the sheet "Calculate" and then I need to find a cell value
in that row in the column number that entered on sheet "Calculate". I need to
get last value in the sheet "Calculate".

Thank you for any hint!

Sheets("FEDEX").Range("A1:A975").Select
For Each Cell In Selection
x = Cells(Rows.Count, "a").End(xlUp).Row + 1
If Cell.Value = Sheets("Calculate").Range("F6").Value Then
ell.EntireRow.Select
For Each Cell1 In Selection
x = Cells(Column.Count, "a").End(xlLeft).Column + 1
If Cell1.Value = Sheets("Calculate").Range("E8").Value Then
Cell1.Value.Select
Next Cell1
Next Cell
End Sub