Hello, I’m trying to develop a sheet where I can easily paste a list of strings into a column and have it return an associated value. I have columns A and B as a catalogue.
|Item|SKU||
|Potatoes|7384||
|Tomatoes|9843||
|Pecans|4207||
|Walnuts|2396||
I want then to paste into column C strings that match cells in column A (C1=Pecans, C2=Tomatoes) that will output either into C1 and C2 (if possible) or into D1 and D2 the associated Column B value from the catalogue (in this case 4207 and 9843). Is there a function for this? So I paste “Pecans” into C1 and “Tomatoes” into C2 and the end result is that either (preferably) in C1 instead of “Pecans” I get “4207” and in C2 instead of “Tomatoes” I get “9843” or the same SKU values get pasted into D1 and D2.
