I want to lookup A1 in column D and return the value from column C - so a negative vlookup.
Match works doesnt it? or xlookup?
yeah index match should work?
seems too hard :)
am just gonna move C to E and vlookup
@.Rodders started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I want to lookup A1 in column D and return the value from column C - so a negative vlookup.
Match works doesnt it? or xlookup?