VBA - Conditional Cell Values

[Rana Gray]

Hello Everyone!
I hope this makes sense... I have a table on [Sheet25], Range F5:F97 & G5:G97

What I want is my host cell ("K8") on [Sheet26] to pull a value (in my case a link) from the aforementioned table based on what value is entered on [Sheet13] ("G11")

example: if [Sheet13] ("G11") = "Smith", then [Sheet26] ("K8") = [Sheet25] ("F5")

I know I can use a nest if statement but I have a giant range which makes for an awful formula I am just super new to VBA and don't know how to code it.

Thanks a Million!!!

 

[Wookiee]

I'm not sure what your criteria are aside from the "Smith" one, but I think this is a good starting point to get you where you want to go.

Sub RanaGray()

Dim rngG11 As Range
Dim rngK8 As Range
Dim rngF5 As Range

With ActiveWorkbook

  'Set Ranges For Evaluation
  Set rngG11 = .Sheets(13).Range("G11")
  Set rngK8 = .Sheets(26).Range("K8")
  Set rngF5 = .Sheets(25).Range("F5")

  'Evaluate Values
  If rngG11 = "Smith" Then rngK8 = rngF5

End With

End Sub

 

[Rana Gray]

I'm not sure what your criteria are aside from the "Smith" one, but I think this is a good starting point to get you where you want to go.

Sub RanaGray()

Dim rngG11 As Range
Dim rngK8 As Range
Dim rngF5 As Range

With ActiveWorkbook

  'Set Ranges For Evaluation
  Set rngG11 = .Sheets(13).Range("G11")
  Set rngK8 = .Sheets(26).Range("K8")
  Set rngF5 = .Sheets(25).Range("F5")

  'Evaluate Values
  If rngG11 = "Smith" Then rngK8 = rngF5

End With

End Sub

Thank you so much!! It is definitely the right direction I appreciate you taking the time to help!!! I never know how to start my script haha