Forum Discussion
vlookup two references from a single cell....
Hi, I have tried searching for this query on forums, but not finding what I require. Basically, I would like to be able to vlookup two references within a single cell separated by a comma/sla...
=VLOOKUP(B9,CHOOSE({1,2},F5:F12&","&G5:G12,H5:H12&","&I5:I12),2,FALSE)
Is this what you are looking for? Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
OliverScheurich Thanks for your reply. I will give this a try and let you know.