VLOOKUP Query

Jonnie White

Wondering if someone can help....

I have two vlookups, both looking at the same source sheet and the same search and return values, only the search and return values are switched. So where on one the data is the search value on the other its the return value and visa versa. As you'll have guessed this poses a problem with the lookup table as the search and return columns need to be the other way around (search value needs to be the leftmost column) for it to work!

Any ideas on how to overcome this?!

Thanks in advance.

Andrée Starå

Hi @Jonnie White

I'd recommend either add a so-called helper column that references the original column or, if possible, use INDEX/MATCH instead.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Jonnie White

I'd recommend either add a so-called helper column that references the original column or, if possible, use INDEX/MATCH instead.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jonnie White

Thanks @Andrée Starå thats worked adding a helper column :)

Andrée Starå

@Jonnie White

Excellent!

You're more than welcome!