So wife does RE work….column A has names of countries. column B has a result like home, remote, hybrid. column A may list a city 2x because it has more than 1 column B result. ie, China might be in column A 2x, with 1 result as home and a second result of hybrid.
On another tab she is listing each city from column A and VLookup formula is pulling in a column B result from the other column B…..but say she types China, the VLookup only pulls in 1 column B result, like hybrid. how can she get that column B to pull in everything listed for chine from the first tab (say home and hybrid)?
thx
On another tab she is listing each city from column A and VLookup formula is pulling in a column B result from the other column B…..but say she types China, the VLookup only pulls in 1 column B result, like hybrid. how can she get that column B to pull in everything listed for chine from the first tab (say home and hybrid)?
thx