Hi,
I have a table that I want to use IF function with to choose which other table it will collect data from and then conditional formatting to tell me if the result is sufficient. It's for parachuting weight limits, first cell that will be selected is the make of the parachute (on a separate worksheet for each manufacturer), next cell will be the size of parachute and then the result will be the maximum weight allowed on that parachute.
Can anyone help me with how I should complete this, or is there another function that would be better suited... LOOKUP
TIA
Scott
Bookmarks