you might be wanting to do the reverse of VLOOKUP . Meaning, when you use VLOOKUP , you're always looking at a left column and getting something to the right of it.

what if I want the item name? What if I want the skew from the item name? They're reversed. I would have to switch around my entire table . But what if I can't switch my table around?

So, I want someone to be able to enter maybe a drop-own menu here. And this drop-own menu from a range I want to say is all of our items.

look there. And our search type, which we could put here. It's optional. I'm going to put a zero. I like doing that. I like doing comma zero for match .

but we're not going to use match as the first thing. It's actually going to be the second item in our formula .

cool. We can jump a bunch of different places. Let's say we want inventory based on the item. All we have to do is change where we're looking after our match to D5 col D.

fun to use. very funible, very flexible alternative to VLOOKUP really you have to have your data in exactly the way that VLOOKUP wants it.