guernica52
New Member
- Joined
- May 3, 2016
- Messages
- 4
Hi Guys,
I have a keyword data dump that has 2 of every keyword (one has data for desktops, one has data for smartphones)
I would like to write a vlookup formula that will first check if the keyword is "desktop". If so, pull the corresponding rank (which would skip over the smartphone rows).
I actually wrote this formula a while ago (lost it now) and it just combined a simple vlookup and if statement. Any help with this formula below would be really appreciated.
client facing tab
<tbody>
</tbody>
raw data tab
<tbody>
</tbody>
I have a keyword data dump that has 2 of every keyword (one has data for desktops, one has data for smartphones)
I would like to write a vlookup formula that will first check if the keyword is "desktop". If so, pull the corresponding rank (which would skip over the smartphone rows).
I actually wrote this formula a while ago (lost it now) and it just combined a simple vlookup and if statement. Any help with this formula below would be really appreciated.
client facing tab
KEYWORD | GOOGLE DESKTOP RANK | GOOGLE MOBILE RANK |
shoes | [if shoes lines up with "desktop", pull the corresponding google rank] | [if shoes lines up with "smartphone", pull the corresponding google rank |
mens shoes | "" | "" |
<tbody>
</tbody>
raw data tab
KEYWORD | DEVICE | GOOGLE RANK |
shoes | desktop | 5 |
shoes | smartphone | 3 |
mens shoes | desktop | 8 |
mens shoes | smartphone | 9 |
<tbody>
</tbody>